MAcro to - copy, transpose, text to columns, remove column A, combine all columns in 1

Hi Jindon,

Sorry, but your code is now only showing the same digit!
The raw data is 600 unique numbers, your code takes the first unique number and repeats it 599 times to give me the same number 600 times