Forum Discussion

fra93's avatar
fra93
Copper Contributor
May 18, 2020

TWO COLUMNS IN PIVOT TABLE

Hi, I hope you can help me.   Is there a way to create a pivot table with two same columns side by side? This is an example.   I have the product ID in the rows, then in the first column (column ...
excel
fra93's avatar
fra93
Copper Contributor
May 18, 2020

I have all my files in my model of Power Pivot. I know formulas to add two pivot tables together but I would like to find a smarter way.

 

I will attach what I would like to obtain.

 

Thanks

bhushan_z's avatar
bhushan_z
Iron Contributor
May 18, 2020

fra93 your data is not ideal for Pivot Table.

You can refer to these videos for guidance:

https://www.youtube.com/watch?v=9NUjHBNWe9M

 

Note: I have not prepared this video.

Resources