Transpose uneven number of values from rows to columns following the same headers

[umbrella26]

Hi,

I'm pretty new to VBA and trying to figure out how to transpose 2000 rows of uneven batches of data.

Here's an example: Column A & B need to become Columns D-H

I would really appreciate some help!
Thank you.

 

[bebo021999]

The output, all the items of a specific group are arranged in a same line, right?
house = house 1, house 2, ..., house 5
...
Is it real data?
If not, we need list of groups and their children (items) of REAL data

 

[umbrella26]

Hi, thank you for responding!

Concerning your first question - yes, that is correct!

Your second question - no the data is not real.
The image I have attached is the closest I can get to sharing real data.

I have colour coded the columns across according to the URL that belongs underneath it.

Do you have any advice/help?

 

[Joe4]

If not, we need list of groups and their children (items) of REAL data

Please be careful about asking for "Real data", as many times, that could get people in trouble over privacy concerns and legalities.
We have gotten numerous requests from frantic people over the years because they posted real data, and their employers were threatening to fire them if they do not remove it!

As a board, we STRONGLY encourage the use of "dummy data" that closely resembles "real data".