Columns Into Rows

Chris - Jul 9, 2009 at 01:34 PM
 Kat - Sep 17, 2009 at 10:24 AM

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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 9, 2009 at 08:02 PM
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!