I hope this is not too trite for the forum.
I have 16 numbers in a vertical list, which I want to convert to horizontal.
I am using Control+C, selecting an empty cell then using Paste Special, ticking Transpose, then OK.
instead of the expected horizontal list of numbers, all that appears is a list of 0s.
I do not understand why and so need help; please.
FWIW I am using a legacy version of Excel.

I have 16 numbers in a vertical list, which I want to convert to horizontal.
I am using Control+C, selecting an empty cell then using Paste Special, ticking Transpose, then OK.
instead of the expected horizontal list of numbers, all that appears is a list of 0s.
I do not understand why and so need help; please.
FWIW I am using a legacy version of Excel.