I have 3000 rows with 25 columns of data. I would like to group data based on the value in one column. This column has numbers (basically a bill of material). So the data is like 1 2 3 4 4 4 5 4 3 4 etc. Basically these numbers represent level of details to get to a part. in the above example first occurrence of 2 means that it is child of 1 and so on.
I would like to group it in a way so that I can expand on each level. I also want all level to come out with a specific color. For example once I click on the + in front of 1 it should list out all the 2 (with a +sign in front of all 2 if there is further detail in 2 and nothing in front of those 2 if there is no underneath information).
Please help me. If I have confused you enough than let me know, I can try to be more clear.