Thanks for the answer. However, when dealing with large amount of data this could be a long time task... Doesn't the pivot table give you the option to completed the information not shown? or using any other more efficient way ?
Thx,
In excel 2003, after getting a summary of my data in a pivot table, (my example below) the table summarizes the information in a way that higher levels conserve the labels (CC1, PA) but lower levels of information will not show it ? ie. in my example, the CC and the Estate are not shown as part...