I've been searching about this problem, testing a lot of options and scripts, but I couldn't find a way to solve the problem.
1) Read/copy the values from specific interval/range by ID;
2) Transpose the values and paste in a specific column;
3) After data transpose must be created a new worksheet - new data format.
The metric is months by kilometers;
The months is from 24 months to 60 months with intervals of 8 (exception from the last one). i.e. 24/16 to 24/80, 36/16 to 36 80 until 60/80.
The kilometers is from 16km to 80km (interval each 8km).
I have to read a range of 9 values (24/16, 24/24,... 24/60) and transpose it to specific column, where this column correspond to specific month (example 24 month).
The values are distributed in columns, but all of them in one line.
A loads of functions and macros at main table.
There are other options to do that, but for the moment the best way is using VB at Excel, that I couldn't get until now. I think the best way is (in loop) get the values in interval of 9, put in arrays, transpose and paste in the correct column.