jmacavali
Fully Optimized
- Messages
- 4,867
Ok, here's the issue.
I have data rows 1-3 and Columns A-COP (it's like 2500 Entries). The data is Name in row 1, Address in row 2, and City/State/Zip in row 3. So it looks like this (ignore the ___ since the forum takes away extra spaces):
________COLUMN A____________COLUMN B
ROW 1:__John Smith____________John Doe
ROW 2:__123 N. Main___________123 N. 1st
ROW 3:__Anywhere, Anywhere___Anywhere, Anywhere
What I need to do is move all the data so that it is in the same format but all in Column A. So it would look like this:
________COLUMN A
ROW 1:__John Smith
ROW 2:__123 N. Main
ROW 3:__Anywhere, Anywhere
ROW 4:__John Doe
ROW 5:__123 N. 1st
ROW 6:__Anywhere, Anywhere
I know I can cut/paste but I don't want to do that 2500 times. Hopefully it's not to confusing on what I mean and what I need.
Any ideas???
I have data rows 1-3 and Columns A-COP (it's like 2500 Entries). The data is Name in row 1, Address in row 2, and City/State/Zip in row 3. So it looks like this (ignore the ___ since the forum takes away extra spaces):
________COLUMN A____________COLUMN B
ROW 1:__John Smith____________John Doe
ROW 2:__123 N. Main___________123 N. 1st
ROW 3:__Anywhere, Anywhere___Anywhere, Anywhere
What I need to do is move all the data so that it is in the same format but all in Column A. So it would look like this:
________COLUMN A
ROW 1:__John Smith
ROW 2:__123 N. Main
ROW 3:__Anywhere, Anywhere
ROW 4:__John Doe
ROW 5:__123 N. 1st
ROW 6:__Anywhere, Anywhere
I know I can cut/paste but I don't want to do that 2500 times. Hopefully it's not to confusing on what I mean and what I need.
Any ideas???