Hello,
May be simple task, but not for me.
I have Excel table . How possible transpose lists by value, like on the picture?
1-44.xlsx (10.5 KB)
Thank you!
What have you tried so far? Do you have your values in a list yet? You need to separate your master list into sublists before transposing.
You’re going to have to provide context and enough information to let us help you. That doesn’t look like your example data. What does your csv data look like? How do you want the data grouped? What have you tried so far to filter and/or group the data. This isn’t a forum for doing other people’s work for them. We need to see some effort.
Example.xlsx (84.9 KB)
Here attached xls file. Colums B, C, D it is coordinates x y z. Colum A it is line numbers 1-56.
I need transorm table, like on picture. All coordinates from first line going in to row 1
| Line | X | Y | Z |
|---|---|---|---|
| 1 | 25977.308 | -36973.967 | 0.62 |
| 1 | 25977.253 | -36973.883 | 0.616 |
| 1 | 25977.198 | -36973.8 | 0.613 |
| 2 | 25977.143 | -36973.716 | 0.609 |
| 2 | 25977.088 | -36973.633 | 0.605 |
| 2 | 25977.033 | -36973.549 | 0.601 |
| 3 | 25976.978 | -36973.466 | 0.598 |
| 3 | 25976.923 | -36973.382 | 0.594 |
| 3 | 25976.868 | -36973.299 | 0.59 |
into
| X1 | Y1 | Z1 | X2 | Y2 | Z2 | X3 | Y3 | Z3 | |
|---|---|---|---|---|---|---|---|---|---|
| Line_1 | 25977.308 | -36973.967 | 0.62 | 25977.253 | -36973.883 | 0.616 | 25977.198 | -36973.8 | 0.613 |
| Line_2 | 25977.143 | -36973.716 | 0.609 | 25977.088 | -36973.633 | 0.605 | 25977.033 | -36973.549 | 0.601 |
| Line_3 | 25976.978 | -36973.466 | 0.598 | 25976.923 | -36973.382 | 0.594 | 25976.868 | -36973.299 | 0.59 |
