Stacking Multiple Columns in New Table

[Anonymous]

Hi! 
I'm kinda of new to PBI and DAX and have been trying to resolve a problem for a few days now, without result. 
I want to create a new Table where i'll stack multiple columns "on top" of eachother. Let me illustrate. 
What i got:

What i want:

I tried using SELECTCOLUMNS and UNION - but I fear that I lack enough knowledge to proceed any furhter. 
Do you have any soulutions i could try?

Thank you!

[amitchandak · Accepted solution]

@Anonymous , Unpivot in power query - other than date

Split by delimiter into column by _ . for the first column -> that will give, question, answer and comment in more column and number in another column

pivot again using column having question, answer and comment and value

https://radacad.com/pivot-and-unpivot-with-power-bi

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Fantastic - With your help I think i can solve the rest! 
Thank you @amitchandak ! 🙂