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:


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: Logo

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

Facebook photo

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

Connecting to %s