Columns Into Rows

Closed

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

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.

Columns Into Rows
How to convert column to row in notepad++ ✓ - Forum - Excel
Excel - Re-arrange data from columns into rows - How-To - Excel
Convert Single Column to Rows, into Matching Rows ✓ - Forum - Excel
Help! Need to copy only some columns in rows that have X condtn ✓ - Forum - Excel
Excel if column contains value then copy row to another sheet ✓ - Forum - Excel

1 reply

Answer 1 / 1

venkat1926

Posts: 1864
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: August 7, 2021

810
Jul 9, 2009 at 08:02 PM

use
edit-copy-edit-pastespecial-transpose

Kat
Sep 17, 2009 at 10:24 AM

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!

Subscribe To Our Newsletter!