Forum Discussion
Help With Multiple sheets and Drop downs
Hello, I have a strange one. I have a sheet (Sheet A, I cannot change this one). Then I have anther sheet (Sheet B, I can edit this one) that has a few selections on it that I would like to crea...
Hi jesfree13 ,
From your description, it should be possible to infer that there is a relationship between the two tables.
I think you could try joining the two tables together using a merge query.
The operation is shown below:
In Power Query Editor, select Merge queries.
From here，choose to expand the fields in the new table column.
Result is as below.
My Sample:
TableA:
TableB:
If you want to know more about the Merge queries, you can refer to the following link.
Merge queries overview - Power Query | Microsoft Learn
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.