Forum Discussion
Alternative to unpivot in powerquery
Hi Everyone, I have two tables which has many columns and rows, so just posting really a sample of it. Is there any way to get the Description column values from the Entries table without unpivot...
Hi, many thanks for your reply. However, these tabless have huge data with large no.of columns more than 50, so it is impossible for me to hardcode like this
Hi debjani1111 ,
Hardcoding is really not a good method if there are many columns, but the need to determine the matching relationship between columns and the fastest way to convert row logic to column logic is still pivot and unpivot.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly