Need to move multiple responses in single cell to single response in multiple cells

**BBExcelusr** · 02-18-2014, 02:05 PM

I am looking for a way to move information that is listed in a single cell into multiple cells, as shown as an example below.

Current Format:

	Label A	Label B
X	1, 2, 3	GG, HH, II, JJ
Y	4, 5	RR, SS, TT

Desired Format:

X	1	Label A
X	2	Label A
X	3	Label A
X	GG	Label B
X	HH	Label B
X	II	Label B
X	JJ	Label B
Y	4	Label A
Y	5	Label A
Y	RR	Label B
Y	SS	Label B
Y	TT	Label B

Any ideas are much appreciated!

**BBExcelusr** · 02-18-2014, 08:12 PM

I should have included an Excel attachment with the same example given. Please see attached.
Excel Example - Single to multiple cells.xlsx

**iamconstance** · 02-21-2014, 04:27 PM

I'm not sure I understand why you have A and B under Column A, Lines 3 and 4 - however, I might use an IF OR statement
i.e:

=if(or(B8=1,B8=2,B8=3,B8=4,B8=5),"Label A", "Label B")

or better yet - if the Label B's are always text and the Label A's are always numbers:

=if(isnumber(B8),"Label A", Label B")

And copy that down

**BBExcelusr** · 02-21-2014, 05:33 PM

I realize now that it probably wasn't smart to use "A" and "B" as my variables. I've updated them to be "X" and "Y" instead to hopefully alleviate any more confusion.

Need to move multiple responses in single cell to single response in multiple cells

LinkBack

Thread Tools

Rate This Thread

Display

Need to move multiple responses in single cell to single response in multiple cells

Re: Need to move multiple responses in single cell to single response in multiple cells

Re: Need to move multiple responses in single cell to single response in multiple cells

Re: Need to move multiple responses in single cell to single response in multiple cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to subtract single cells with double digits into a single digit of a single cell.

[SOLVED] move data from multiple worksheets to single sheet whithout manually entering each cell id

Transpose copy paste multiple columns of a single row to a multiple rows in a single colum

Dealing with single and multiple responses

Need to move text from a single cell and spread them out amongst multiple columns

Bookmarks

Bookmarks

Posting Permissions