I was wondering what the best way to achieve the attached transformation would be using Power Query.
I am keen to use power query because I want the result to be 'Connection Only' which I then intend to merge with another query.
Any thoughts would be greatly appreciated.
Thanks,
Martin
Bookmarks