Forum Discussion
JeremyLeee
Helper I
Helper IExpand multiple columns in power query
Hi All, Is that possible to expand 'value' for all the columns at once? I could do it one column by one column (see the expanded second column) but that is too slow. Thanks in adance, Jeremy...
Hi JeremyLeee ,
- Check the column(s) that don't contain data to be expanded (in your case it looks just like "Column1.timestamp"
- Rightclick your mouse and click "Unpivot other columns"
- Expand "Value" from the new "Value" column
- Ask yourself if you should dance the happy dance right now (because your data is in the shape that's actually best suited for the data model) or you first need to pivot it back
- optional: If you actually want to bring back the values into one column each, check the new "Attribute" column -> on the Transform tab, choose "pivot column" -> choose "Value" in the field "Values column"
If the execution time of this query takes too long, I might have a quicker solution, but that requires some coding.
v-piga-msft
Resident Rockstar
Resident RockstarHi JeremyLeee ,
Have you tried with the suggestion of ImkeF ? Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry