Forum Discussion
Split up different data sets in same columns into their own worksheets
We recently tried out a piece of equipment that collects data for walking/gait analysis. The software for the equipment gives instant analysis and individual tables. However, when off-loading the data to view in excel, it combines all the data for the individual subject in a single .csv file. we had 26 separate files, with 5 data segments each (98 total rows). I used query to combine all 26 .csv files in the folder. I am looking for the best path to create macros or formatting that can allow me to separate the data segments into the individual excel sheets, that isn't copy and paste. Looking to build like an automated template where any .csv file I add to the folder gets added and sorted into the correct sheets.
Adam, is it possible for you (without including any actual names of clients) to post a copy of the actual spreadsheet you get after this import into Excel? Post it on OneDrive or GoogleDrive and put a link here that would grant access to the file.
I'm asking that, so as to see the actual file. From the brief description you give, it might be that you'd be making your task more difficult by continuing to separate the data segments.....Excel can do some wonders when it comes to parsing data; it's often the case that people get in the way of letting Excel do the heavy lifting because it makes more sense to us as people to look at separate tables. But Excel, as I said, can take a single table and do lots..... So let us see (if you are willing) what you're actually working with before you go, possibly, down a rabbit trail you needn't follow.
Thanks for offering your assistance. I made the post just before leaving for the day and was having issues with uploading the file. The google drive link should work for seeing the file. The first tab is the combined data set files.
Thank you kindly
- You have to grant access as well. You'll get a request from me via email to do that, but if you want others to also have access, you need to make it publicly accessible.
