How to separate variables within a column

[manyquestions]

Hi

I need help. I have want to separate one column into two. But I don't want
to sort or filter, I want to make two extra columns, so I can view the data
side by side, how do I do it?

eg
make

A 2 x
A 2 y
B 2 x
B 2 y

into
x y
A 2 2
B 2 2

 

[Ron Coderre]

A Pivot Table would easily do what you want.....

With
A1:C5 containing these values
Letter Amount Category
A 2 x
A 2 y
B 2 x
B 2 y

Then....from the Excel main menu:
<Data><Pivot Table>
Use: Excel
Select your data: A1:C5
Click the [Layout] button
ROW: Drag the Letter field here
COLUMN: Drag the Category field here
DATA: Drag the Amount field here
If it doesn't list as Sum of Amount...dbl-click it and set it to Sum
Click [OK]
Click the [Optons] button
UNcheck: Grand totals for columns
UNcheck: Grand totals for rows
Click [OK]
Select where you want the Pivot Table...and you're done

The final Pivot Table will look like this:
Sum of Amount Category
Letter x y
A 2 2
B 2 2

Is that something you can work with?

Post back with more questions.
***********
Regards,
Ron

XL2002, WinXP