Pick only first non blank cell from each row

[Cyber20]

Hi,
I have spreadsheet with Months(Columns) under with amount but some months has not amounts, what I want to do is create another spreadsheet exaclty same formate but only want to display the first non blank cell in one spreadhsheet and in another spreadsheet the second non blank cell. any help would be kindly appreciated.

this is original spreadsheet[TABLE="width: 500"]
<tbody>[TR]
[TD]Jan
[/TD]
[TD]Feb
[/TD]
[TD]Mar
[/TD]
[TD]Apr
[/TD]
[TD]May
[/TD]
[TD]June
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100
[/TD]
[TD][/TD]
[TD]10
[/TD]
[TD][/TD]
[TD]200
[/TD]
[/TR]
[TR]
[TD]200
[/TD]
[TD][/TD]
[TD]2000
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


only first non blank cell to be displayed[TABLE="width: 500"]
<tbody>[TR]
[TD]Jan
[/TD]
[TD]Feb
[/TD]
[TD]Mar
[/TD]
[TD]Apr
[/TD]
[TD]May
[/TD]
[TD]June
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]200
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

only second blank cell to be displayed[TABLE="width: 500"]
<tbody>[TR]
[TD]Jan
[/TD]
[TD]Feb
[/TD]
[TD]Mar
[/TD]
[TD]Apr
[/TD]
[TD]May
[/TD]
[TD]June
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]2000
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]