I have data in column A with 5 rows of info for each name stacked on top of each other that I need to separate into columns.
A12 Joe
A13 Smith
A14 27
A15 2/23/85
A16 Carpenter
A17 Pete
A18 Jones
and so on
I want to copy the first 5 rows and move to column B and paste transpose the date to columns B to F.
Then move to the next 5 rows and repeat each time I call the macro with a button or keyboard shortcut. The starting point has to be where I put the cursor for the first time which could be A17 or A84 or anywhere else. I've looked a little and can't find out to move the cursor. I used to do this in Quattro Pro.
Bookmarks