Drop down data not loading when running power query

[dclrvtt01]

I have 4 workbooks. Each contains two columns of data pulled from drop-down lists. When I use Power Query to combine the workbook data, everything comes over except from the two columns that contain drop-down data. How do I get Power query to pull this data over? Thank you.

 

[sandy666]

Post link to shared excel file with representative example of source and expected result. Use DropBox, OneDrive, GoogleDrive or any similar.