0
EDIT: To show data is not just numerical
I would really appreciate some help if possible please! I have some data in a LibreOffice spreadsheet that is structured like this:
+----+---------+-------+--+ | ID | Quality | Value | | +----+---------+-------+--+ | 1 | Height | 123 | | | 1 | Weight | 456 | | | 1 | Name | Jon | | +----+---------+-------+--+
But I need to transpose the data to show like this:
+----+--------+--------+-------+ | ID | Height | Weight | Name | +----+--------+--------+-------+ | 1 | 123 | 456 | Jon | +----+--------+--------+-------+
It's a long file - 85,000 rows, otherwise I'd just do it manually! I have access to LibreOffice, awk, sed, and any other Linux tools. If it came to it I could find a way to use Excel.
Any ideas please? And is transpose the right word?
Many thanks in advance!
"Transpose" is "mirror at the diagonal". So that's not excactly what you have to do. How look the other rows? Are there several ID's? Are there more different qualities? – IQV – 2017-03-29T10:29:53.383
Is the sequence of your rows always the same in quality column (Height, Weight, Depth, Height, Weight, Depth...)? – yass – 2017-03-29T11:16:21.460
You can use
Index / Match
with Excel just a formula for each column and you can drag it – yass – 2017-03-29T11:57:44.403Thanks for the replies! There are many different Qualities and not every ID has the same Qualities listed. I'll look into Index / Match, thank you yass. – M Harwood – 2017-03-29T12:13:37.590