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
What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,372
- 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
