Transform table with Pivot Table, DAX formula

[Fractalis]

Hello to all,

I'm new with Pivot Tables, DAX formulas and I want to know if it is possible to get the output desired with PT, Power Pivot, DAX etc.

I'm using Excel 2016.

This is my input Table:

[TABLE="class: tableizer-table"]
<tbody>[TR="class: tableizer-firstrow"]
[TH]DESCRIPTION[/TH]
[TH]VALUE[/TH]
[/TR]
[TR]
[TD]STAGE[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]JFMSC[/TD]
[/TR]
[TR]
[TD]TYPE[/TD]
[TD]MLRR[/TD]
[/TR]
[TR]
[TD]DFRUL[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]ADDR[/TD]
[TD]1001[/TD]
[/TR]
[TR]
[TD]RRUL[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]SPRR[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]ISGALW[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ISUTWD[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]STAGE[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]PLLSJS[/TD]
[/TR]
[TR]
[TD]TYPE[/TD]
[TD]MLRR[/TD]
[/TR]
[TR]
[TD]DFRUL[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]STAGE[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]AAAARR[/TD]
[/TR]
[TR]
[TD]TYPE[/TD]
[TD]MLRR[/TD]
[/TR]
[TR]
[TD]DFRUL[/TD]
[TD]R2[/TD]
[/TR]
[TR]
[TD]ADDR[/TD]
[TD]3553[/TD]
[/TR]
[TR]
[TD]RRUL[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]SPRR[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ISGALW[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ISUTWD[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ADDR[/TD]
[TD]66444[/TD]
[/TR]
[TR]
[TD]RRUL[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]SPRR[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ISGALW[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ISUTWD[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ADDR[/TD]
[TD]890087[/TD]
[/TR]
[TR]
[TD]RRUL[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]SPRR[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ISGALW[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ISUTWD[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]STAGE[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]PPROOA[/TD]
[/TR]
[TR]
[TD]TYPE[/TD]
[TD]RRHN[/TD]
[/TR]
[TR]
[TD]DFRUL[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]ADDR[/TD]
[TD]7034[/TD]
[/TR]
[TR]
[TD]RRUL[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]SPRR[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ISGALW[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]ISUTWD[/TD]
[TD]FALSE[/TD]
[/TR]
</tbody>[/TABLE]


And this is the output I'd like to obtain:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]STAGE[/TD]
[TD]ID[/TD]
[TD]NAME[/TD]
[TD]TYPE[/TD]
[TD]DFRUL[/TD]
[TD]ADDR[/TD]
[TD]RRUL[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]JFMSC[/TD]
[TD]MLRR[/TD]
[TD]P1[/TD]
[TD]1001[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]PLLSJS[/TD]
[TD]MLRR[/TD]
[TD]P1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]4[/TD]
[TD]AAAARR[/TD]
[TD]MLRR[/TD]
[TD]R2[/TD]
[TD]3553[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]66444[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]890087[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]PPROOA[/TD]
[TD]RRHN[/TD]
[TD]P1[/TD]
[TD]7034[/TD]
[TD]P1[/TD]
[/TR]
</tbody>[/TABLE]

Is possible or only with VBA macro?

Thanks in advance

 

[brawnystaff]

Probably with Power Query...

https://www.thebiccountant.com/2019/02/28/unstacking-columns-in-power-bi-power-query-excel/

 

[Fractalis]

Probably with Power Query...

https://www.thebiccountant.com/2019/02/28/unstacking-columns-in-power-bi-power-query-excel/

Thanks for your answer. I tried to do the example in the liks you shared and is not working.

If you know about Power Query, may you give me the steps more in detail please.

 

[brawnystaff]

Your right, that example was not as good..

Was able to find a better one at URL below, but only deals with one column vs. your two..

https://www.mrexcel.com/forum/power-bi/971926-unstacking-column-variable-intervals-data.html

 

[Fractalis]

Thanks so much for the links shared. Have helped me.

Best regards