Copy DropDown List Data into a New Workbook with Power Query

[ScottTemple]

Hello,

I have a dropdown list in column G in Workbook1, but when I use Power Query to bring over all my data into a new blank workbook, the data in column G changes to a data format. I only need to bring over the value listed in each cell, not the dropdown format. The data contains text, such as: 6/4, 6-6-2, CP.

Workbook 1 vs. 2

 

[Kerryx]

Did you try to foramt the data in G as "Text" as this would copy in inot PQ as text and push it back out as text with no changes

Book2
	A	B
1	grade
2	6/4	grade
3	6-6-2	6/4
4	cp	6-6-2
5		cp
Sheet1

 

[ScottTemple]

That's what I thought too, but it still comes across incorrect. I have both sheets listed as text.