AnsweredAssumed Answered

Excel Pivot Table

Question asked by lewinn on Jul 27, 2019
Latest reply on Aug 6, 2019 by curtvprice

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!