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.


    Dear all,

    Fairly new to macros. So have attached the input sheet and desired output. The array needs to be transposed in column with category being repeated. Also need to skip subtotal and blank rows.

    The headers are not required in the output.

    Thanks in advance