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