Help with data wrangling

hcova

New Member
Joined
Jul 29, 2010
Messages
26
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
You have both the Source Data Table and the Target Table mentioned in my previous post.
 

Attachments

  • Table with data.jpg
    Table with data.jpg
    194.2 KB · Views: 4
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,246
Members
452,623
Latest member
cliftonhandyman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top