Combining Data based on common value

**mohsin.bipu** · 10-21-2021, 04:22 AM

My dear expert,
I come up with another problem. Need your help. From the input chart, I want to create a summary output chart based on combining common price and region code. I looked many places, But could not get the solution. I can do this with Excel VBA. But looking for a solution with Excel formula. Is it possible with Excel default formula?

Thanks in advance for your help.

Input chart:
Inout.png

Output:
Output.png Output.png

**AliGW** · 10-21-2021, 04:33 AM

Administrative Note

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. Thanks.

**alansidman** · 10-21-2021, 04:37 AM

Can be achieved with Power Pivot. You will see that I have built a new measure to accumulate the data. See the attached file. This will probably be available to you if you are using a newer version of Excel. Are you still using XL2007? If not, please update your profile to reflect the latest version you have.

Here is the tutorial: https://sfmagazine.com/post-entry/ju...a-pivot-table/