Hi I am trying to replicate in power query what in excel could be ;
I have managed this but it took a lot of nesting list transformation, I have include a version where I named all the steps individually for clarity![]()
Please Login or Register to view this content.
if anyone has any ideas on simplifying this I would like to know, I have thought of using records, but have not tried yet.![]()
Please Login or Register to view this content.
Richard
Bookmarks