ScottTemple
Board Regular
- Joined
- Dec 28, 2023
- Messages
- 103
- Office Version
- 365
- Platform
- 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
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