Macro for unexpected scenario

Hi,

I have data like below in excel sheet.Sheet1 contains similar type of records nearly 3000records in below format.I need to add data from row2 to row13 to Number.I need macro for adding below records from row2 ro row13 to column number

Any one provide macro for this

sheet1:

empid name loc age player Number
1 a b c d 1
2
3
4
5
6
7
8
9
10
11
12

Output:

empid name loc age player Number
1 a b c d 123456789101112

Hi jOakin,

I have Remove the comment for Range("F2").Value = sNumber.its working fine.But the problem is It is working only for one row only.
After A12 i have rows like that only.But it is not working for remaining records.

Hi Joakin,

Plase check the attached dat for reference.sheet1 contains input data.sheet2 contains output data.sheet1 has many number of records i have added only 3 records for reference.

Hi Joakin,

Thx for the code.But the problem is some of the rows coming with different length.You hardcoded in your code for 11.But some of the rows contain only 3 records.So in that case it is failing.
So macro should concatenated that records to last column whenever row has only one column data.