formula to convert manual cross tab to list

[adambalt]

I have a manually created crosstab that I want to convert to a series of lists. Here is the example:


TABLE: Class1 Class2 Class3
Name1 1
Name2 1
Name3 1
Name4 1 1

RESULTS Class1 Class2 Class3
Name1 Name3 Name2
Name4 Name4

I would like to have the bottom section automatically populate based on the top section so that a "1" can be entered and based on the "1"s a list forms underneath (or on another tab, does not matter) with the Class as a heading and the names listed below. I would like to keep this to one step, not keep filtering, copying and pasting.

I did have a related post that provided a VBA solution, but I am looking for a formulaic solution, if possible.

LINK to prior post:
http://www.mrexcel.com/forum/showthread.php?t=600547

Thanks one and all!