How do I translate my data set in a row into a column

[AccruedExpenditure]

I've been trying to find an automated way to this? Anyone know?

i.e.

You have data in a row

10 15 15 53 35 35 35 35 35

and you want them to go down in a column

10
15
15
53
35
35
35
35
35

 

[RaynorWolfcastle]

I forget what it's called but there's a built-in function for that, I think it's called transpose or something similar.

 

[Bootprint]

Originally posted by: RaynorWolfcastle
I forget what it's called but there's a built-in function for that, I think it's called transpose or something similar.

Yep, paste special and select transpose.

 

[AccruedExpenditure]

Originally posted by: Bootprint

Originally posted by: RaynorWolfcastle
I forget what it's called but there's a built-in function for that, I think it's called transpose or something similar.

Yep, paste special and select transpose.

Sweet Leroy Brown, it worked.

Thanks

 

[RaynorWolfcastle]

:beer:😀

 

[yukichigai]

Paste Special is the dope shiz niggly.