I got a one-colum data list with the following make-up in Column A
it starts with a 9 digit number with hyphens and one space
the next tow to three cells below are just text
Then comes the next 9 digit number and so forth.
What I would like to achieve using a macro is the following:
The macro is to select the first number in A1 and the two cells below (i.e. from A1 to A3) and then go to B2 and do a transposing action
The macro goes on selecting the next 9 digit number in Cell A4 and the three cells below (i.e. from A4 to A7) and then selects B4 and does a transposing action
and so forth.
I hope I could make myself clear.
Help is much appreciated. Thank you very much in advance for your valuable help.
I have attached a sample file for your convenience.