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:
<tbody>
</tbody>
And this is the output I'd like to obtain:
<tbody>
</tbody>
Is possible or only with VBA macro?
Thanks in advance
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