I have multiple tables (tab X1-6) where few columns are common in all and last column is different. I want to combine all tables as one (tab X7) with common columns and last column from all tables appearing side by side using power query. attached is a demo file.
Power Query
Please Login or Register to view this content.
CorrectionPlease Login or Register to view this content.
This M code does not hardcode any columns, and so you can add more tables as long as the table names start with "t_".
Please Login or Register to view this content.
Last edited by josephteh; 03-28-2024 at 04:49 AM.
thanks Czeslaw and Josephtel for your support. if possible, can you look into it. I want to add all the values in each row based on description column.
3 queries created:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks