Copying fields in same row to below A1

[mt1013]

Hi

I have, for example, employee names in field A10.
To the right, in the same row, are columns of data that are related to the the initial employee name in A10 (or below).
These are the dependents.

There could be 1, 2, 3, 4 or 5 dependents.
To the far right, (after the last dependent column) I have counted each dependent(i.e.1, 2, 3, etc.) for each row (there are a max of 5 dependents).

I would like to find a way to copy the dependent names in (let's say) columns H10 to P10 based on the number of dependents and paste them under the destination in field A10 (the dependents are related or grouped to the employee name)

There are 12000 of these records. Is there someone who can give me some advice on who to do this?

This is something I need to automate. I already manually inserted the rows based on the number of dependents to the right (1, 2, 3, etc) and I have the counter number of dependents in a column to the right. (this was a LOT of work).

My guess is the code would have to search for the column that has the number of fields (dependents) that need to be pasted.

Thank you very much.


Post edited by moderator to remove unreadably large font and bold text.


.

 

[vletm]

1) You could use smaller font without bold; much easier to read.
2) Upload a Sample File to get a quicker response