Quote:
Originally Posted by hiwire03
Trying to figure out a formula to rearrange data in the existing table to the desired table. Tried the 'Manage Data Model' but was unable to figure it out. Any guidance is highly appreciated.
|
The concept in essence is the reversing of the pivot table. Found the solution here
https://www.youtube.com/watch?v=pUXJLzqlEPk
(Just for everyones benefit)