I'm sorry, I don't. Hopefully someone else with this type of expertise can
help. Best of luck with it.

"Dina" wrote:

Sorry, I should clarify:

My data contains over 3000 entries. There are duplicates by name. The
maximum number of duplicates is 5. I would like to find an automated way to
go through the data and for each duplicated name do what the example showed.

Do you know of a way to do that?

Thanks in advance

"marysully" wrote:

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!!