You are reading a single comment by @rhb and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
rhb
aggi
Powerquery is the good answer, but there is a bit of a learning curve. If it's going to be a regular occurrence then this is the route I would take.
Free RDB Merge add-in will just paste everything together into one workbook
https://macexcel.com/examples/addins/rdbmerge/
You'll need to remove the headers in the middle of your data (just filter and delete) and obviously you'll run into trouble if the combined data is more than a million lines.
EDIT: Just noticed that is the Mac add-in and he has taken the Windows site down. I've no wonder if Mac add-ins work in Windows (and I assume you're using Windows) but if you need the Windows add-in drop me a PM and I'll send it over.