Last week, I spent an hour trying to get 3 columns from one csv file into another. Started with Index/Match, then reluctantly went to Vlookup. Nothing was working. I would name my ranges, enter the functions and when I clicked “enter”, I was staring at the formula itself…no data. I finally got it to work after I realized my target column was set to “text”. I know Power Query, and I know I could have/ should have used it. But old habits are hard to break. Thanks for this reminder.
This video was great! Thank you!!!!Is it possible to add new columns before you load the data merge to new worksheet? Example I need it to take a date on the sheet and add 90 days but I need the value in a new column.
Absolutely! You can always go back into Power Query and add more transformations to the data; then, when you hit "close and load" at the end of your changes, your changes should be reflected in the data in the spreadsheet.