Hi there.
How can I write a VBA code to arrange the source data table in the included picture?
1) The source data table is shown in columns A to N
2) The columns P to AG show the Target Data Table I need.
3) This Target Table is built by extracting part of each odd row (odd in this example only) and pasting it into column Q.
Then paste the complete even row before the complete odd row (even only in this example) in the same row.
For instance,
the line P2 : AG2 in the Target Table is built with A3 : E3 and A2 : N2
the line P3: AG3 is built with A5 : E5 and A4 : N4
and so on.
Best Regards
Hernan
How can I write a VBA code to arrange the source data table in the included picture?
1) The source data table is shown in columns A to N
2) The columns P to AG show the Target Data Table I need.
3) This Target Table is built by extracting part of each odd row (odd in this example only) and pasting it into column Q.
Then paste the complete even row before the complete odd row (even only in this example) in the same row.
For instance,
the line P2 : AG2 in the Target Table is built with A3 : E3 and A2 : N2
the line P3: AG3 is built with A5 : E5 and A4 : N4
and so on.
Best Regards
Hernan