Forum Discussion
Matching columns in two spreadsheets
I have a larger spreadsheet with email addresses in one column and a lot of other demographic data in the other columns. I have a second, smaller, spreadsheet also with email addresses in one column....
Hi SpaceAge you could try using PowerQuery to merge the files. Upload it using Get Data in Data tab and when in excel, select merge queries as New. It will create a new table and you can close and load the file into yoir excel workbook