HELP WITH EXCEL TABLE FORMULA

[xsubzeroz]

My question would be a little long. I have from cell A2 to A50 numbers. In cell B2 to B50 I have formula that calculates SUM of some cells. In Cell C1 to N1 I have January to February. Now in C2 I have formula that says if A2=1 (1 for January) then type B2(SUM formula result in B2), in C3 if A3=1 then B3. Same thing for column D. In D2 if A2=2 (2 for February) then type B2. After I finished putting numbers in column A, under January to December the numbers all over the place according to number in column A. Now what I need to know If I can type lets say in A100 to L100 "January to December" and underneath each month pick number from previous table in line them up.

(example what I have in table)
A B C D E F G
1 Jan Febr Mar Apr May
1 2 2.5 2.5
2 3 3.5 3.5
3 2 6.5 6.5
4 1 8.5 8.5
5 2 4.5 4.5
6 3 2.4 2.4

(example what I want after)
A B C D E
Jan Febr Mar Apr May
100 8.5 2.5 3.5
101 6.5 2.4
102 4.5
103
104

 

[xlhelp]

Forgive me for being the self appointed commissioner of duplicate postings, but, you posted this question yesterday. If you needed to refresh it, you could go back to the same post add to it asking if anyone has an answer instead of posting it again. It's just a waste of valuable server space.

The question you are asking probably needs a macro, unless our database expert Dale Watson knows a way to extract it.

 

[xsubzeroz]

Sorry for posting question again. I'm new user and still don't know all the rules and how it works. I thought if message was not replied then its gone so thats why I reposted.