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.
Read the rest of this entry »


Row to column in Gnumeric

I have some spreadsheet data which I want to present in columns, instead of the rows that I initially entered. I searched a bit and found instructions for Excel here. The principle is the same, so here’s what I did for Gnumeric. Read the rest of this entry »