Header in row to column
 

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.

Header in row to column
 

Refer your previous post.

If this post helps click Yes
---------------
Jacob Skaria


"Venice" wrote:

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.