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