VBA Code to Re-organise Transposed Data ?

[mave27]

I have transposed a sample set of ROW Data to COL Data:

FROM:

column.jpg

TO:

ROWS.jpg

I now want to re-organise the transposed COL Data to format below:

cat.jpg

Anyone care to share VBA Code to re-organise the data as shown in screenshot above ?

Below the aesthetic points to "factor" into the code:

1. Col Data D-F (3 Cols) should start from ROW #6, Col Data G-I (3 Cols) should start from ROW #11 and so on...
2. Create Blank Col on Col B & Col D - shown by Yellow Tint on screenshot
3. Create successive Blank Rows on 5, 10, 15, etc,etc.. - shown by Yellow Tint on screenshot

Real sample data is about 17K+ of Col Data, so it's quite a challenging VBA code to write.

In short: i want a max of 3 Cols of Data on worksheet page, with next 3 to start from another ROW, separated by Blank Row & so on.

** Once the data is re-organised in the desired format, i will manually re-size the Col & Row width.

Thanks in Advance.

[millz]

This is assuming your transposed data starts at A1, the re-organized data will start at A6
try:

Please Login or Register  to view this content.

[mave27]

This is assuming your transposed data starts at A1, the re-organized data will start at A6
try:

Please Login or Register  to view this content.

Great - code has done exactly that !!

Do you mind modifying the code to output the Result on a New worksheet ?

[millz]

Try this, I did not test it though:

Please Login or Register  to view this content.

[mave27]

Thanks - Works fine !!