I am attempting to use Power Query to clean data from SharePoint and would appreciate input to help extract record and list values without creating all sorts of duplicate rows or messy merges.
I would like to be able to create two new columns, side by side with the existing columns. For each row of the SharePoint table I would like to achieve the following:
Goal 1 - The first new column would show the extracted value for the Label row from the record. Image 1.
Goal 2 - The second new column would navigate through the list, to the record and then extract the value for the “Title” row. Images 2a & 2b.
Can someone please suggest m-code that might achieve this cleanly?
Thanks for your time.