I have two tables in separate sheets. I want to merge these tables into a single one but the issues is they have unequal lengths (see example in workbook). I tried to merge using query function but this led to loss of data from Table 1.
Is there a way I can make such a merger? Any suggestion is much appreciated, thank you.
This is simple with Power Query (Get & Transform Data).
Format your source data as tables (Table1 and Table2), then use:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks