I'm also looking for the same, did you found anything, if
so, pls share here. Thanks.

Regards.

-----Original Message-----
Hello,

I am looking for an easy way to take data listed down in
rows and move
them to another spreadsheet as column values. the data
looks
something like this:

ColA,ColB

Day, 1
Apples, 20
Orange, 10
Grapes, 5
Day, 2
Apples, 9
Orange, 7
Grapes, 3

and I want it to look like this :

Day Apples Oranges Grapes
1 20 10 5
2 9 7 3

The amount of days will change, but the data rows
associated to each
day will always be 20. The end column name headers will
also be
constant (i.e. Apples). I also need this to be a macro.
I am using
Excel 2002.

Any ideas on how to do this?

Thanks in Advance!
.