Transform horizontal data to vertical data

[christian79]

Hello,

I have a sheet I need to transform from data being stored horizontally, like the following:

Company ID 1	DoB 1	Name 1	DoB 2	Name 2	DoB 3	Name 3
Company ID 2	DoB 1	Name 1	DoB 2	Name 2
...	...	...	...	...	...	...

Into the following:

Company ID 1	DoB 1	Name 1
Company ID 1	DoB 2	Name 2
Company ID 1	DoB 3	Name 3
Company ID 2	DoB 1	Name 1
Company ID 2	DoB 2	Name 2

The data is structured such that the DoB/name entities always occur in as above horizontally (so that offsets can be used).

I've written a VBA script identifying and coloring/counting all the DoBs, but I need one row for each DoB/name entity, in relation to the company ID. Being a one-time operation and thus making performance uninportant, I just loop over all rows and identify things based on offsets.

How can I break each row up into several rows and paste the parts sequentially after eachother?

Thankful for any help!

 

[Fluff]

@gargamalebarbosa as this is a significantly different question, please start a thread of your own. Thanks

 

[JvdV]

@Fluff sorry, I replied to the question and seen your comment afterwards. Please delete if need be.

 

[gargamalebarbosa]

@gargamalebarbosa as this is a significantly different question, please start a thread of your own. Thanks

ok

 

[gargamalebarbosa]

@Fluff sorry, I replied to the question and seen your comment afterwards. Please delete if need be.

sorry @JvdV , i started a new thread.

Thank you and have a good day,