can I write multiple cells to a single cell?

Yes, you can combine data from multiple columns into a single cell using our Merge Columns feature. To do this: 1. Click Add Column 2. Select Merge Columns 3. Input your formula to combine the desired columns Additionally, if you have list data in a cell, you can combine items into one text field to join all items into one line, separated by commas.

Source: Manage cell data | Documentation | Clay University

There's no specific limit mentioned for how many columns you can merge using the Merge Columns feature. However, each cell has a character limit of 8,000 characters, so your merged content cannot exceed this limit. The main constraint would be the total character count of your combined data rather than the number of columns being merged.

Source: Table columns | Documentation | Clay University