|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 8th, 2009, 08:02 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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. 
|
|
#2
November 8th, 2009, 08:26 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
