Hi,

I have a data set that looks like this:


Code:
--------------------
Name City Rating Type
Dave London 5 Audi
Dave London 4 Ford
Dave London 7 BMW
Tom Dallas 6 Audi
Tom Dallas 9 Bentley
--------------------




Is it possible to combine rows so that I have only one row per name?

So I need something like this:



Code:
--------------------
Name City Audi Ford BMW Bentley
Dave London 5 4 7 -
Tom Dallas 6 - - 9
--------------------



The number of types can vary and not all names will have a particular
type. Basically I need to dynamically create columns.

Any ideas?


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