Please try to do following steps:

Copy the date you want

Paste Special in the sheet where you want

Please refer to the following picture:

Select my_Row1=max(isnull(case when rn=1 then mob_no end,'')),

my_Row2=max(isnull(case when rn=2...