Using power query in excel to combine 3 excel spreadsheets into one error field content of the record was not found???
I am using power query editor to import 3 excel workbooks into one workbook. I took these steps 1. Create new workbook 2. under – data – new query - from file – from folder (Path containing the 3 files) then transform then add column. 3. I created my new column name then added the formula Excel.Workbook([content]). I chose content in the choices
I get the following error message and it will not merge the files. Expression.Error: The field 'content' of the record wasn't found.
I get the same for each of the files I want to merge??? Not sure how to resolve
Did you select Combine & Load after you'd selected the folder and the files were listed?