Posts by onitz

    Hey Glenn, A pivot based approach won't help. There are multiple sheets of different companies and also the incremental data will be added as different sheets.

    Hey Alan, The product category needs to repeated for each of the transposed figure.

    Also there are multiple sheets with similar kind of information, some rows are merged which needs to skipped, the subtotals need to skipped and blank rows also needs to be skipped.

    Looking for more formula/ macro based approach.

    Thanks in advance.