Hi all,
I am having some trouble splitting data by the information in the headings. I want to compare certain variables (GT, AC etc) between two groups (x & y) across a certain duration (Run).
If I utilise graph builder with the above table format there is a fair amount of clutter:
I was thinking there would be some way to add another column to each of the current columns, marking one half of the data as belonging to x - and the other half of the data as belonging to y. That way I could split the data in the graph builder by the variable x/y. I haven't managed to find a way of doing that so far, though I am guessing there is perhaps a basic way around this issue. I thought about labelling values or choosing an option from the tables dropdown like subset but I appear to be gated by ineptitude.
Would anyone be able to provide a suggestion on how to sort out my table, or knows of a thread where this sort of issue may have been covered previously?
Thanks,
Callum
You could try stacking columns first. And then split the Label column into two different columns to get name and coordinate.
Start:
Stacked:
Then from colums menu you can find Text To Columns and use it on Label column
