Merging rows with the same customer name but different data values.

Thanks so much for the quick help!
But.. i just saw that the document i have is a little messier then i first thought.
It are statistics from a company here in Holland, so the data is a bit sensitive.
I'll give you a little part so that i can explain what the next problem is.

There are some names that have only ordered something in two or one of the three years.
How can i handle that? Remember, the document is 10000 lines long, so manual work is not really loved...

Thanks in advance,
Berry

Originally Posted by BB1972

Hi berryh,

Welcome to the forum. You should upload a small sample workbook - contributors are rarely keen to rebuild your spreadsheet as a precursor to assisting you.

And if I can ever speak (type) a foreign language as well as you can English, well, I'll be pretty pleased! Excellent.

Thanks

See the post above, just added an example!

Originally Posted by BB1972

Berry, will there definitely only be one entry per year, per company?

Yes. There will only be one entry per year, per company. I can even get the a separate file for every year if you want it.

Originally Posted by BB1972

Okay, well if you have a separate file for each year, then let's take the path of least resistance Have a look at the attached, where I have a tab for each year, and have copied your information for each year to the relevant tab.

I presume you have a master list of all the companies somewhere? If so, put that in Column A of the Yearly Totals tab, as I have done. Then the INDEX/MATCH formula in eg B2 looks for a match for A2 (Haardhout Ferwerd) in Column B of tab 2010, and if it finds a match, it returns the correspnding value from Column D (2010 tab) to Column B (Yearly Totals).

Changing the tab references etc in Columns C & D (Yearly Totals tab) allows you to look in the other tabs (2011, 2012) in a similar manner.

Adjust ranges etc to suit, and you should be sorted

Hope this helps,

I'm going to try this now, thanks for the information.
I'll let you know once i'm done and if it worked or not.
Thanks again!

Berry

Originally Posted by BB1972

Okay, well if you have a separate file for each year, then let's take the path of least resistance Have a look at the attached, where I have a tab for each year, and have copied your information for each year to the relevant tab.

I presume you have a master list of all the companies somewhere? If so, put that in Column A of the Yearly Totals tab, as I have done. Then the INDEX/MATCH formula in eg B2 looks for a match for A2 (Haardhout Ferwerd) in Column B of tab 2010, and if it finds a match, it returns the correspnding value from Column D (2010 tab) to Column B (Yearly Totals).

Changing the tab references etc in Columns C & D (Yearly Totals tab) allows you to look in the other tabs (2011, 2012) in a similar manner.

Adjust ranges etc to suit, and you should be sorted

Hope this helps,

Brendan, Sir,
You're a hero!
After tweaking your code a little so that it compares the customer numbers and not the names, (That created duplicate numbers of some sort) it worked outstandingly!
I would never have come up with this code! Thanks so much, you saved me a LOT of work!

Thanks once again!
Berry

I'll do that now!

Probably hang around here some more.

Thanks for the help.
Berry