Are there any Excel pivot table experts out there? Example:
ID School City
1. Ball State University Muncie
1. Ball State University New Castle
I have two records that have the same ID and school, but two different cities. I’d like for it to look like this (all on one line):
ID School City1 City2
1. Ball State University Muncie New Castle
I assume I need to use a pivot table, but can’t figure out how to get it onto the second column.
You win if you can tell me how to do this!