LinkBack URL
About LinkBacks
Good morning,
I have a list of data in a spreadsheet like:
A B
1
2
3
4
...
...
I need to make it like:
A B
1 2
3 4
... ...
The number of rows will be different each time, so I have set "rc as Long" for my row count. I'd appreciate any suggestions.
Good morning,
I have a list of data in a spreadsheet like:
A B
1
2
3
4
...
...
I need to make it like:
A B
1 2
3 4
... ...
The number of rows will be different each time, so I have set "rc as Long" for my row count. I'd appreciate any suggestions.
Last edited by jhighland; 05-03-2021 at 02:13 PM. Reason: Solved
Something like next code you want ?
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
No. That just moved column A starting at row 6 over to column B.
Instead of:
A B
1 2
3 4
5 6
7 8
9 10
11 12
... ...
It gave me:
A B
1 6
2 7
3 8
4 9
5 10
- 11
- 12
("-" representing an empty cell, "..." representing continuation of data)
Last edited by jhighland; 05-03-2021 at 12:52 PM.
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Should be attached. Thanks.
See after
Please Login or Register to view this content.
Re: Data in single column to two columns
That worked beautifully! Thank you! I'm a novice that just knows the bare basics, so I'm looking forward to spending a little time figuring out how it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks