Split one row of data to columns and rows

actually I don't need the formatting

I attached the file after add and run the macro

it should be :
No.1: 6 digits
No.2: 4 digits
No.3: 13 digits
No.4: 11 digits
No.5: 16 digits