how to move cells from down to across

S

Sarah

Morning- How can I move cells that are likethis:
Col 1 Col 2 Col 3
Row 1 Blue 7 1020
Row 2 Red 8 512
Row 3 Pink 11 718
Row 4 Blue 15 1122

Into:
Col 1 Col 2 Col 2 Col 3 Col 4
Row 1 7 8 11 15
Row 2 Blue 1020 1122
Row 3 Red 512
Row 4 Pink 718

I hope this is clear enough for you. I'm at a loss. Many
Thanks! Sarah
 
D

Dave Peterson

Is that data really numeric?

If yes, you could add a header row to your data.

Color Value1 Value2

Then select your data (including the header row) and do
Data|pivottable.

follow that wizard (just click Next until you get to step 3 (with a button
called Layout on it).

Click that Layout button.

Drag color to the row field
drag Value1 to the column field
drag Value2 to the data field.

If you see "count of value2", just double click on it and change it to sum.

Click finish.

I like to convert the pivottable to text (select all, copy|paste
special|values).

Then I can reformat it to the way I like.

(but I do lose the pivottable.)
 
Top