Column to cell in a spreadsheet

I have a list of gene names in a spreadsheet column hat I need to transform to a row. Using the transpose function does not do the job, because gene names should be in a single cell, comma separated. So, I searched a bit and found the TEXTJOIN function.

So, I have the genes in column A, cells A1:A8. The formula that does the job is:

=TEXTJOIN(",",TRUE,A1:A8)

Like this:

Now I have them nicely in a cell. Why I need this? I’ve been preparing gene markers for the ScType workflow, by Ianevski & Giri, 2022.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s