Forum Discussion
Split up different data sets in same columns into their own worksheets
https://docs.google.com/spreadsheets/d/10m9QP9obPUXRR7hInFfwu7Dki2KLVe0w/edit?usp=sharing&ouid=106318099948916850013&rtpof=true&sd=true
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
OK, got the file. Brought it into Excel. Now you need to tell us what we're looking at. I've tried the FILTER function on the Gait Table rows, but that's clearly not getting all that you'd want.
- It's probably me, making things harder than it needs to be. I'm trying to transpose each of the data measures to their own columns. For example, the Gait Table segment, has number of strikes, cadence, gait time, gait distance, gait velocity (cm/sec), Gait velocity/leg length. Trying to figure out the best way to make each of the different types of measure in their own columns in the corresponding worksheet (gait table, step-stride table, etc.). makes the data easier to look at data correlations if one column is one type of measurement and the next column is different. Not sure if there is a good way to do that other than manually sort for each data set and copy/paste the data over.
If you can manually sort and then copy/paste, you should also be able to use FILTER with criteria....what isn't clear to me (as an outsider to your dataset) is what I'm looking at in the "raw data", how to identify what is one data set vs another.
Here, though, is a good introductory video to understand FILTER and SORT--relatively new functions--that might be your answer.