Thanks Bob.

However, the data can be more complex. Each person can have dirreftent
ratings for the same car. So


Code:
--------------------
Name City Rating Type
Dave London 5 Audi
Dave London 7 Audi
--------------------


And ideally the output should be something like


Code:
--------------------
Name City Rating Audi1 Audi2
--------------------


Is this possible?


--
beanmonger
------------------------------------------------------------------------
beanmonger's Profile: http://www.excelforum.com/member.php...o&userid=27982
View this thread: http://www.excelforum.com/showthread...hreadid=474905