Hi Andrew,

Not sure if I have a solution or can come up with one. I assume the data is
not exactly as your example and is probably much more extensive.

But I would be glad to look at your worksheet if you are willing to send it
and take a shot at it.

Remove NOSPAM from my e-mail address.

Regards,
Howard

"Andrew" wrote in message
om...
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!