I have this spreadsheet (Open Office) and all the data is filled in so they form a col, and I would like to change this so they fill a row instead. Kind of mirror the doc in both axis.
This is how it looks today
D1 D2 D3 D4 D5 Name1 01 02 03 04 05 Name2 10 11 12 13 14
And then I would like to transform the data so the data comes in rows instead.
Name1 Name2 D1 01 10 D2 02 11 D3 03 12 D4 04 13 D5 05 14
Is there a function in Open Office (Libre Office) that can do this?