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:

DESCRIPTION	VALUE
STAGE	1
ID	0
NAME	JFMSC
TYPE	MLRR
DFRUL	P1
ADDR	1001
RRUL	P1
SPRR	TRUE
ISGALW	FALSE
ISUTWD	FALSE
STAGE	1
ID	2
NAME	PLLSJS
TYPE	MLRR
DFRUL	P1
STAGE	1
ID	4
NAME	AAAARR
TYPE	MLRR
DFRUL	R2
ADDR	3553
RRUL	P1
SPRR	FALSE
ISGALW	FALSE
ISUTWD	FALSE
ADDR	66444
RRUL	P1
SPRR	FALSE
ISGALW	FALSE
ISUTWD	FALSE
ADDR	890087
RRUL	P1
SPRR	FALSE
ISGALW	FALSE
ISUTWD	FALSE
STAGE	1
ID	0
NAME	PPROOA
TYPE	RRHN
DFRUL	P1
ADDR	7034
RRUL	P1
SPRR	FALSE
ISGALW	FALSE
ISUTWD	FALSE

<tbody>
</tbody>

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

STAGE	ID	NAME	TYPE	DFRUL	ADDR	RRUL
1	0	JFMSC	MLRR	P1	1001	P1
1	2	PLLSJS	MLRR	P1
1	4	AAAARR	MLRR	R2	3553	P1
					66444	P1
					890087	P1
1	0	PPROOA	RRHN	P1	7034	P1

<tbody>
</tbody>

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