Excel 2008 : merging data from multiple rows

[sgtpepper91179]

Hey Everybody,

I'm hoping someone can help with my excel problem here. I have a list of over 500 merchants and their sales from last year as well as this year. Merchants who had sales for both years have duplicate entries with the numbers in different columns. I wanted to merge the duplicate rows so that each merchant has only one row of data showing both 2011 and 2012 sales. I've attached a before spreadsheet as well as one that shows how I'd like it to look after.

The main challenge I'm having with this is that I'm using Excel 2008 for mac so I can't use any VBA solutions as it isn't supported. Does anyone else know of an easy way to merge the data?

Thanks for any help!

after.xlsx

before.xlsx

[JBeaucaire]

Use a Pivot Table.

http://screencast.com/t/LMTswFlQxrLe

[sgtpepper91179]

That worked awesome, thank you!

[JBeaucaire]

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.