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 dat...
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.
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.
