Copy DropDown List Data into a New Workbook with Power Query

ScottTemple

Board Regular
Joined
Dec 28, 2023
Messages
103
Office Version
  1. 365
Platform
  1. Windows
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
1708538736883.png
1708538757596.png
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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
AB
1grade
26/4grade
36-6-26/4
4cp6-6-2
5cp
Sheet1


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

1708696851722.png
 
Upvote 0

Forum statistics

Threads
1,223,894
Messages
6,175,250
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top