V
Venice
I have the following data:
Row 1 has 3 columns that is B1 = Opening, C1 = Spent, D1 = End balance. From
E1 to G1 it has the same header. Every 3 columns has the same header (they
are indicating the opening and balance of different date).
Row 2 is the numbers date for column.
My intention is to sort each header by 1 column. Hence, there will be only
ONE column for Opening, 1 for Spent, and 1 for End balance). Any function
that allows me to do this? Thanks.
Row 1 has 3 columns that is B1 = Opening, C1 = Spent, D1 = End balance. From
E1 to G1 it has the same header. Every 3 columns has the same header (they
are indicating the opening and balance of different date).
Row 2 is the numbers date for column.
My intention is to sort each header by 1 column. Hence, there will be only
ONE column for Opening, 1 for Spent, and 1 for End balance). Any function
that allows me to do this? Thanks.