Forum Discussion
transformation with power query
Hi Anonymous
In Queries Editor,
1.create a index column from1,
2.create a conditional column
3. fill down on [custom] column
4.click on [atributo] column, select "pivot table"
5.fill down in [nombre] column,
fill up in [value] column,
after these, click on the "down arrow" of [type machine] column, select "remove empty"
finally, you could remove useless columns.
Best Regards
Maggie
Community SupportHi Anonymous
In Queries Editor,
1.create a index column from1,
2.create a conditional column
3. fill down on [custom] column
4.click on [atributo] column, select "pivot table"
5.fill down in [nombre] column,
fill up in [value] column,
after these, click on the "down arrow" of [type machine] column, select "remove empty"
finally, you could remove useless columns.
Best Regards
Maggie
v-juanli-msft Thank you very much for the help, this is the answer I was looking for, just brilliant.
again thanks for coming to help me