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.
Read the rest of this entry »
Shorten contents of spreadsheet cells
Posted: 2020-08-05 Filed under: academic, office | Tags: Cell values, function, gnumeric, left, shorten, spreadsheet Leave a commentI have a spreadsheet file with a list of species’ Latin names. I want to automatically create abbreviations for each species, by shortening both the genus and specific epithet to a certain number of characters. Here’s how to do it.
Read the rest of this entry »
Row to column in Gnumeric
Posted: 2016-08-30 Filed under: academic, office | Tags: Cell values, column, gnumeric, row, spreadsheet, transpose 2 CommentsI 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 »
Cell values as rows in a spreadsheet
Posted: 2014-04-17 Filed under: academic | Tags: Cell values, gnumeric, sort, spreadsheet Leave a commentI have some spreadsheet data where the first column lists the position of a certain amino acid within a protein. There are many amino acid sites that are skipped, therefore the rows do not follow the actual, uninterrupted, amino acid sequence. Read the rest of this entry »
Slackalaxy 