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.
Nice video, pretty easy to understand
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.
No doubt, using VLOOKUP can be a very frustrating experience!
This was excellent, so easy to follow. Thank You!
Glad you enjoyed it!
thank you
Thanks 👍
Very useful Gentleman..
Glad you enjoyed it!
Thanks very much.
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.