Forum Discussion
JessTaylor95
Jun 17, 2024Copper Contributor
Combining Excel Files
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)
- kris10yagerduarteCopper ContributorHave you tried the VSTACK function? There are several tutorials online to show you. That might help. Good luck!
- JessTaylor95Copper Contributor
I tried this but couldn't work out how this works as my data is displayed vertically across multiple tabs and I will have fresh data every month. Any ideas?