Sorting by multiple TRUE entries, a challenge for Excel experts!

[alanbarry]

Hi all,

I have a sheet as follows;

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1800[/TD]
[TD]18001[/TD]
[TD]18002[/TD]
[TD]18003[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD]TRUE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1235[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1236[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1237[/TD]
[TD][/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I need to do is sort this so that;

All 1800 TRUE cells are grouped together
All 1800 + 18001 TRUE cells are grouped together
All 1800 + 18001 + 18002 TRUE cells are grouped together
etc etc

to give me a table like this;
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1800[/TD]
[TD]1800 + 18001[/TD]
[TD]1800+18001+18002[/TD]
[TD]18001+18002[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1235[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1235[/TD]
[TD][/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1235[/TD]
[TD][/TD]
[TD][/TD]
[TD]TRUE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1237[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TRUE[/TD]
[/TR]
</tbody>[/TABLE]

For all possible combinations! This will allow me to quickly look and see which codes (eg. 1800, 18001) are grouped together by a TRUE classification.

It is complicated, because as you can see, the 1235 designation will appear across three of these categories (1800, 1800+18001, 1800+18001+18002).

I would be really grateful if someone could help here! If I have explained this badly, please do let me know!

Thanks,
Alan.

 

[alanbarry]

*Bump* I really would appreciate any help on this