Is there a Power Query feature that can transpose a table by key columns, similar to the "Transpose by Key Columns" function in the Ablebits set of tools?
There is a built in transpose feature but it doesn't give me the desired result as this does, because I can't set a key column, and would love to keep my automation all within powerquery.
If you google search for "ablebits transpose by key columns" you will see what I mean. I would past the link in here but I am not allowed.
Bookmarks