I have 5 separate spreadsheet files (example below) laid out like this that all need combining.

Each file contains different data but the headers in bold are the same.

I tried to combine these using power query but came across 2 main issues and didnt get very far:

1. I have no option to select ‘folder’ as a data source (all the 5 spreadsheets are kept in 1 folder)

2. All the examples I could find are using data spread across columns, not in rows like mine. I have tried transposing my data but it needs to be kept in these rows.

Can anybody please advise me the best solution here?

(I am using a mac and will receive new data every month)

​I have 5 separate spreadsheet files (example below) laid out like this that all need combining.Each file contains different data but the headers in bold are the same. I tried to combine these using power query but came across 2 main issues and didnt get very far:1. I have no option to select ‘folder’ as a data source (all the 5 spreadsheets are kept in 1 folder) 2. All the examples I could find are using data spread across columns, not in rows like mine. I have tried transposing my data but it needs to be kept in these rows. Can anybody please advise me the best solution here? (I am using a mac and will receive new data every month)  Read More

​