You could do it in two steps. First do your normal text to columns. Then
follow this up with a copy and paste special/transpose.
Will

"A.S." wrote:

I wanted to see if there was anything that could do text to rows instead of
text to columns. For example:

49159;49176;49179

so the data would look like:

49159
49176
49179

Thanks.