Power Query Merging two queries with dropdown

[ursua]

Hi,
I am merging two tables in PQ. One of them contains a list of numbers (and some other columns too), the second contains a list of numbers in a table that contains few columns (let them be B:E) with a dropdowns there. Some cells are empty, some have values chosen from dropdowns. When I am merging two tables I expand those B:E in the first table and get values that are chosen in the second from dropdowns and that's ok but dropdowns are obviously not copied.
The question here is: can PQ keep dropdowns not only values chosen? So after refresh I will get a table that contains as a result expanded columns from the second table WITH values chosen from dropdowns AND dropdowns still active copied from the second table?

 

[johnny51981]

When your data source includes a drop down, Power Query will only read what is populated (or null if not). The Data Validation (or dropdown) will not translate to be present in the second table.

You can, however, add the Drop Down to the second table after its initial load to limit any updated selections. You will have to make sure they are using the same list, otherwise you will receive an error in the second table when it loads a value that isn't included in that drop down set up.