Paste vertically to Excel cells of horizontal numbers copied from webpage

[mfhaq77]

Hi there,

I Copied the following numbers from a webpage and paste-special as text. I tried to make the numbers placed vertically in contiguous cells by using Transpose command but in vain.

Copied Numbers
211001 , 211101 , 211201 , 211301 , 211503 , 211601 , 211701 , 211801 , 213801 , 214501
211901 , 212001 , 212101 , 212201 , 214001
212305 , 212407 , 212505 , 212609
212701 , 212801 , 212901 , 213001 , 213101 , 213201 , 213301 , 213401 , 213501 , 213601 , 213701 , 214401

The numbers got pasted in A1 B1 C1 D1 in sigle cells.

How can I place the numbers vertically in contiguous cells in a column?

I am using Office 365 Offline



Rgards,
Fazlul