I have thousands of CSV files all with the same data structure - A1:A6 (Header) and B1:B6 (Data). I'd like to copy the data into a single sheet with the following data sctrucutre: A1:F1 (header), A2:F2 (data) then repeat A3:F3 (new data).
I tried using Jerry Beaucaire's - Excel Assistant CSV to Rows, but I was unable to get the funciton to work properly. It just kept copying the header info over and over.
Any help would be appreciated.
Perhaps have a look at https://www.rondebruin.nl/win/s3/win021.htm
Thanks for the idea. Unfortunately, I get a compile error when running that code. I'm on Mac Excel if that has anything to do with it.
Then I would suggest modifying your profile accordingly ( which won't solve your problem but attract Mac users' attention)
Thanks. Done. Hopefully someone will catch it.
As you have the 2019 version of Excel, Power Query may be an option for completing this task. Linked below is a video (will have to endure a short commercial) that talks about compiling multiple files into either a spreadsheet (@1M rows) or data model (millions of rows)(this section begins around the 21:50 mark) depending on the size of the files involved.
https://www.youtube.com/watch?v=ohGFPF12Qwc&t=1275s
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks