Help, confusing cell extraction

[InvictusInflictus]

I need the formula to start looking from the top of the column list of revenues and find the first cell that has number data in it, and the second, third, forth and so on, until 60th. This data then needs to be displayed in a horizontal row. Month 1, Month 2, and so on.


In this case, it will put the number data from October into Month 1 on the row at the top. It should continue with November as Month 2.

I should mention, this starting point will change, This time is October, next time it can be any other month that will begin as Month 1


I've tried some code which worked initially but when I tried to move the reference cells to find my data, it stopped working. Been at this for 2 days, need help.


Thank you to all the smart folks out there...much appreciated.


(This should be accompanied by a photo, but I can't seem to upload it.)


[TABLE="width: 1140"]
<tbody>[TR]
[TD]January[/TD]
[TD][/TD]
[TD="align: right"] -[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Month 1[/TD]
[TD]Month 2[/TD]
[TD]Month 3[/TD]
[TD]Month 4[/TD]
[TD]Month 5[/TD]
[TD]Month 6...and on[/TD]
[/TR]
[TR]
[TD]February[/TD]
[TD][/TD]
[TD="align: right"] -[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD](start insert here)[/TD]
[TD]next one here[/TD]
[TD]next one[/TD]
[TD]next one[/TD]
[TD]next one[/TD]
[TD]next one[/TD]
[/TR]
[TR]
[TD]March[/TD]
[TD][/TD]
[TD="align: right"] -[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]"617,800" here[/TD]
[TD]"543,380" here[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD][/TD]
[TD="align: right"] -[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD][/TD]
[TD="align: right"] -[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD][/TD]
[TD="align: right"] -[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD][/TD]
[TD="align: right"] -[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD][/TD]
[TD="align: right"] -[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]September[/TD]
[TD][/TD]
[TD="align: right"] -[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]October[/TD]
[TD][/TD]
[TD="align: right"] 617,800[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]November[/TD]
[TD][/TD]
[TD="align: right"] 543,380[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]December[/TD]
[TD][/TD]
[TD="align: right"] 575,413[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]January[/TD]
[TD][/TD]
[TD="align: right"] 593,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]February[/TD]
[TD][/TD]
[TD="align: right"] 552,290[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]March[/TD]
[TD][/TD]
[TD="align: right"] 543,959[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD][/TD]
[TD="align: right"] 433,534[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD][/TD]
[TD="align: right"] 168,052[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD][/TD]
[TD="align: right"] 588,197[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD][/TD]
[TD="align: right"] 625,581[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


...and so on...

 

[Fluff]

Hi & welcome to MrExcel
If the - in your post is 0 displayed as - then try

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L
1							Month 1	Month 2	Month 3	Month 4	Month 5	Month 6...and on
2	January						617800	543380	575413	593000	552290	543959
3	February
4	March
5	April
6	May
7	June
8	July
9	August
10	September
11	October		617,800
12	November		543,380
13	December		575,413
14	January		593,000
15	February		552,290
16	March		543,959
17	April		433,534
18	May		168,052
19	June		588,197
20	July		625,581
Data

Cell Formulas
Range	Formula
G2	=INDEX($C$2:$C$20,AGGREGATE(15,6,ROW($C$2:$C$20)-ROW($C$2)+1/($C$2:$C$20>0),COLUMNS($A:A)))

 

[Joe4]

Cross-posted: https://www.excelforum.com/excel-general/1269617-help-with-data-extraction-on-my-spreadsheet.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[InvictusInflictus]

Thanks for bringing this to my attention.

Cross-posted: https://www.excelforum.com/excel-general/1269617-help-with-data-extraction-on-my-spreadsheet.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[InvictusInflictus]

Thank you for your solution.

 

[Fluff]

You're welcome