Column to cell in a spreadsheet
Posted: 2023-04-30 Filed under: office | Tags: Cell values, excel, gene, row, sc-type, spreadsheet, transpose Leave a commentI 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.