I have been send a spreadsheet that is set up like the example below

A
1 60112,"1"
2
3 60113,"1"
4
5 60114,"1"
6
7 60121,"1"
i need to remove the blank cells(e,.g A2,A4 etc) and get rid of the
punctuation then in Cell B2 i need the otther number so it would look like
A B
1 60112 1

the spreadsheet has about a thousand rows can this be done or will it have
to be done manually which would take a considerable amount of time as i have
about 20 of these to do a day

I posted this question yesterday but it appears to have dissapeared so if
this is a duplicate apologies


Thanx for any help