View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
marysully marysully is offline
external usenet poster
 
Posts: 32
Default How to combine rows?

Insert columns. Select Company column, right click to Insert column. Select
City column, right click to insert column. You will then have your 5 columns.

"Dina" wrote:

How can I do this?

Name| Company | City
Jon Smith| IBM| Toronto
Jon Smith| TD| montreal

into this:

Name| Company | Company2 | City | City 2
Jon Smith| IBM | TD | Toronto | Montreal

Thank you!!