B
bill_s1416
I need to horizontally sort a table. It's laid out as follow
left-to-right:
Row1: blank, product1, product2, product3, product1, (repeating)
Row2: Territory, Jan, Jan, Jan, Feb, (repeating)
I need to horizontally sort it such that the 12 product1 columns (Ja
--> Dec) are all together, product2 are all together, etc.
Can anyone help with a macro?
P.S. The complete data table's range is A1:AK51 comprised of 1 colum
of territory numbers and 36 columns of data (3 products x 12 months.
left-to-right:
Row1: blank, product1, product2, product3, product1, (repeating)
Row2: Territory, Jan, Jan, Jan, Feb, (repeating)
I need to horizontally sort it such that the 12 product1 columns (Ja
--> Dec) are all together, product2 are all together, etc.
Can anyone help with a macro?
P.S. The complete data table's range is A1:AK51 comprised of 1 colum
of territory numbers and 36 columns of data (3 products x 12 months.