Forum Discussion
PowerPivot Table
the easiest way is to have 3rd table with all the unique Seller Names and do joins from that table (you can do that in Power Query/Get & Transform in the Data ribbon if you use Excel 2016)
or you could append table 1 & 2 but first adding an identifier column for type of sale
Sale Type Seller Name Amount regular John 607 regular Ben 834 WIP John 503 WIP Ben 456
the easiest way is to have 3rd table with all the unique Seller Names and do joins from that table (you can do that in Power Query/Get & Transform in the Data ribbon if you use Excel 2016)
or you could append table 1 & 2 but first adding an identifier column for type of sale
| Sale Type | Seller Name | Amount |
| regular | John | 607 |
| regular | Ben | 834 |
| WIP | John | 503 |
| WIP | Ben | 456 |
Hey Stacho, thanks for your comment!
Actually there is a database behind the tables, each database has a lot of sales lines that I agreed to the pivot table. Thats why I'm trying to do that in PowerPivot tool.
that's perfectly fine, you can still connect to the database and make this kind of changes
best way to do it is with Power Query (so you don't have to copy & paste anything). If you're using PowerPivot connections then I'd recommend rebuilding them in PQ