Parsing Data

[Shabu-Shabu]

I have a column of data:

X
Y
X
Y
X
Y
X
Y
X
Y
etc.

I need to separate this into a column of Xs, and a column of Ys. Other than copy/paste, what's the most efficient way to do this?


Thanks!

 

[luke1438]

Assuming your data is in column "A":
In column "B" type:

=IF(A1=Y, Y, 0)

In column "C"

=IF(A1=X, X, 0)

Then drag the formulas down.

 

[Shabu-Shabu]

I should've been more specific...

I have TWO columns of data:

A B

X 198.342
Y 287.939
X 549.654
Y 277.478
X 432.565
Y 352.519
etc.

I need column B parsed into Xs and Ys. I like the IF statement approach; can it look at column A and act on column B?

Thanks again for the help!

 

[Aladin Akyurek]

Looks like the X and Y's follow a regular pattern of "every other". If so, see my contrib in:

http://www.mrexcel.com/board2/viewtopic.php?t=129703

 

[Shabu-Shabu]

Outstanding!

Aladin -

It works perfectly! I don't understand it, but Thank You Very Much!