Hi
It wasn't your fingers that were incorrect, it was my posting.
I missed an opening parenthesis after the word TEXT in the second formula.
Obviously you corrected that.
If you are saying you want the Names lined up with the dates in adjacent
columns, then place cursor in cell C1 and right click>Insert>Shift cells
down.
That will align your data.
An easy way to get rid of the blank rows in between your data, is to mark
the columns B and C (after your Paste Special), then Data>Sort>No header
row>Column C>Ascending and all of the blank rows will "fall to the bottom".
If the order of your data needs to be preserved, then before carrying out
the above, Enter 1 in cell D1, 2in cell D2. Mark both cells and grab the
fill handle (small black cross at bottom right of cell D2) and drag down as
far as required.
Include column D in your sort.
Delete all the "surplus" rows (i.e. those with just a number in column D and
nothing in B or C), then Sort columns B
again, this time by column D and
your data will be back in the original order. Then delete column D