ST Alpha - "Excel Question" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 158

Excel Question

Posted by Mel Profit (aka Mel Profit) Jul 9 '21, 12:52

I need Excel Help.

I have one column with a single entry. I have the column next (column 2) to it with multiple entries.

How to I delimit out so the multiple entries in Column 2 are broken out but I retain the single entry in Column 1?

Even if I break out Column 2 into multiple rows and Column 1 with the single entry in one row and blanks in all other corresponding rows - that's fine. I'm looking to pivot this out.

Also, hope all is well.

Responses:

You wanted the column two values to be given their own rows? I would do a VBA script to write them onto a second sheet. Then it would be easy to ... - zork Jul 9, 15:42 2
- I was wondering if that was the solution. Looks like I'm going to be looking into VBA...first time in a long while. Thanks. -- nm - Mel Profit Jul 9, 15:56 1
  - Yeah, a while ago I could have done that in no time. - zork Jul 9, 16:18
Are the multiple entries in column 2 delimited somehow (tab, comma)? -- nm - spamlet Jul 9, 12:57 3
- They are technically with [ ] Symbols -- nm - Mel Profit Jul 9, 13:27 2
  - Ah so they are [a] [b] [c]? With a different number of responses in each row? -- nm - spamlet Jul 9, 13:29 1
    - yep. I need to tie Column A with just it's one entry to Columns B and C which have multiple entries in one cell. -- nm - Mel Profit Jul 9, 15:40
Can you copy column 2 to the last column, then use Text to Columns? Data >> Text to Columns -- nm - JaxSean Jul 9, 12:56 2
- (the reason I say copy to the last column is that I don't know how many values you have in column 2.) - JaxSean Jul 9, 12:58 1
  - I can have any where from 2 to 8 entries in column two. - Mel Profit Jul 9, 13:28

Post a message top

Excel Question

Replies are disabled on threads older than 7 days.