Pivot report on multiple columns (Updated with data sample provided)

Hi everyone,

I am currently dealing with a project involving Power Query and was hoping someone could share their light with me. 

I have tried many ways, read posts on this forum as well so I could reach the expected result but can't seem to find the best route to get there. Not quite sure existing solutions offered don't work. I suspect this is due to calculations not always offering the same results.

Context: The report lists options calculated for individuals. Not everyone is receiving the same option ("NUM_OPTION_OFFERED").

The attached might be self-explanatory but in short, I am trying to pivot a few columns in this report so that each calc ID will result into one single line that will list all options and their underlying data horizontally. 

Note:

Fields CALC_ID,RESULT_ID and ID will always be matching, the options and underlying data are the one resulting in several rows.

"OPTION_TYPE_DESC" will always match its "NUM_OPTION_OFFERED".

The formatting is just to ease the reading of my explanation.

Finally, while there is a way to run this in a matrix visual, I was have this performed in PQ. 

Thanks in advance for any help!

ps: I didn't find a way to upload the data sample but happy to do so if I can find guidance. Thanks

Link to Data Sample (Dummy data) used to illustrate the above:
https://docs.google.com/spreadsheets/d/1t4fRVmDT3ksWPRuQG0dNLSeZnSznhS5A/edit?usp=share_link&ouid=101605191992442888907&rtpof=true&sd=true