J
jeff.campagnola
I have a dataset in Excel like this:
Place Person
--------------
City1 Name1
City1 Name2
City2 Name1
City2 Name2
City2 Name3
What I need to do is manipulate the data into one row for each city,
with each name in a separate columns. Please note that there is a
varying number of names for each city. My result should be like this:
Place Person1 Person2 Person3 ... Person9
-----------------------------------------------
City1 Name1 Name2
City2 Name1 Name2 Name3
I have tried pivot tables and data consolidation but to no avail. There
are close to 2000 names, with up to 15 names in each city.
Thanks
Place Person
--------------
City1 Name1
City1 Name2
City2 Name1
City2 Name2
City2 Name3
What I need to do is manipulate the data into one row for each city,
with each name in a separate columns. Please note that there is a
varying number of names for each city. My result should be like this:
Place Person1 Person2 Person3 ... Person9
-----------------------------------------------
City1 Name1 Name2
City2 Name1 Name2 Name3
I have tried pivot tables and data consolidation but to no avail. There
are close to 2000 names, with up to 15 names in each city.
Thanks