So, I've got this data set coming from questionnaires. I created one table per question, questionnaires in rows, answers in columns, and everything is fine and dandy, but now I have this situation where the questionnaires pertain to a number of different groups. So I created a table associating the ID of the questionnaires with their group, and then I sorted it and I've got a nice aggregated view of questionnaires' IDs grouped together depending on their group.
Now I'd like to sort all my other tables' rows accordingly. Is this even possible? I know I should have done this before beginning to import the data…
EDIT Sample document at http://www.morpheu5.net/public/sample.zip
Example of what I start with:
And (below image ) if you sort table "Condition" by column "c", you get a different sorting of the head column with the IDs.
This and the sorting I need to replicate on table "Q5.6…"
EDIT 2 I temporarily "solved" by copying column "c" from table "Condition" to all the other tables and used that to sort accordingly. I'm not marking this as my answer in case somebody comes up with a more efficient/correct way.