Columns Into Rows

Closed
Report
-
 Kat -
Hello,

I have a data field which I am trying to rotate from Horizontal to Vertical. I am new to macro's.

So my data is set is:
Pet: Dog
Name: Ginger
Sound: Bark

And I want to rotate the data to look like this:
Pet Name Sound
Dog Ginger Bark

How can this be done?

Thank you in advance for your help.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
use
edit-copy-edit-pastespecial-transpose
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Hi! When I insert the transformation how can I insert new empty rows as well?
I have to make "Text to rows" transformation, to put the texts in new rows and not to overwrite the cells below.Thanks for help!