Transposing data from columns 1

[DDP]

I want to change data from this

Row Column Value
1 1 5
1 2 6
2 1 7
2 2 8

to this:

Row Column
1 2
--- ------
1 5 6
2 7 8

I cant seem to figure it out using VLOOKUP, any suggestions?

 

[IDS]

>>
I didn't say that "nothing is better", I said that I couldn't find anything that is better.
<<

OK, if you use Excel mainly to access data from a database I can see the "big file" features would be unimportant, and if the process has become more cumbersome I can understand your frustration.



Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/