Hello,
This was supposed to be a very simple task but i have exhausted all i knew in PowerPivot and that's way decided to reach out to the pros.
If you take a look at the file attached you will see that in order to achieve a asymmetric data transfer from input table into pivot table most like we will need to create row numbers in PowerPivot. However, doing this in PowerPivot is not so easy.
I will appreciate any ideas.
Excel File is here: Row Number.xlsx
Capture.PNG
Bookmarks