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
Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,174
- 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
- Locked
- Question
