I have a large list of addresses in column "A". I would like to separate them into 4 columns. Each address is separated by a blank row. The main issue occurs when an address has 4 lines of data instead of 3. Everything gets shifted. I have tried an offset formula and also the WRAPROWS formula. I can't seem to get past the forth row of data. Can someone help? Maybe this can be solved easier with a loop in which starts back at Column "C" after each blank row. please see the below example.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
SEPARATE LARGE COLUMN INTO 4 COLUMNS
- Thread starter rikvny02
- Start date
Excel Facts
Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,488
- Office Version
- 365
- Platform
- Windows
@rikvny02
For the future, please take note of #14 of the Forum Rules in relation to your thread titles.
For the future, please take note of #14 of the Forum Rules in relation to your thread titles.
Upvote
0
Similar threads
