Splitting Information in columns into seperate rows

Not sure how you can judge whether it's simple or not, but anyway here is one approach:

Please Login or Register  to view this content.

Thank you for your help, now lets say I increased the number of columns for either the standard data or the variable contact information data, how do I account for those changes in the macros you provided. I dont really understand what is going on it.

Change the nCol line. It still assumes your subsequent cols are grouped in twos.

Please Login or Register  to view this content.

I think this will cater for columns being grouped into 3s or whatever - change nSeq line.

Please Login or Register  to view this content.

Thank you that was very helpful! It tells me sometimes object required, do you know why at the Sheet1 current region line?

To be honest, I cannot think what causes that. Can you post a sample which illustrates the problem?

I haven't had time to look through yet, but I don't think 7 and 3 works because you have 5 columns which do not vary and then 3 which rotate so your ncol would have to be 8 I think.

EDIT: in any case the code did not work, but I think this sort is out:

Please Login or Register  to view this content.

thank you that worked perfectly