How can I sort a column with associeted tables inside the cells [Excel]

Asked Sep 20 '18 at 09:44

Active Sep 20 '18 at 09:44

Viewed 17 times

I have an excel table with associated tables inside cells. This is an example:

If you click on "+", you can see the associated table:

I tried to sort the column PSM from highest to lowest. The problem is that excel doesn't respect the associated column and this one is sorted as well.

That is to say, what I would like to have is a sort rows by PSM where each row has its associated table. One example of this table can be downloaded from here

Thank you in advance

edited Jun 20 '20 at 09:12

Community

asked Sep 20 '18 at 09:44

Enrique

This is probably offtopic for Stackoverflow. Try https://superuser.com – mb21 Sep 20 '18 at 09:46
This might be more easily done during table creation – Ron Rosenfeld Sep 20 '18 at 10:20
That table is created by a program. I cannot change the options @RonRosenfeld – Enrique Sep 20 '18 at 10:24
In that case, I don't know any method of doing this without using VBA to take the table apart; sort it how you want; then put it back together again. – Ron Rosenfeld Sep 20 '18 at 18:49

How can I sort a column with associeted tables inside the cells [Excel]

0 Answers0