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!