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
Display two columns in data validation list but return only one - Guide
Excel change columns to numbers - Guide
How to delete rows and columns in word - Guide
Google sheets right to left columns - Guide
How to combine debit and credit columns in excel ✓ - Excel Forum

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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!

Similar discussions

Converting rows of data in notepad to columns

Comparing columns and returning value

Extract identical cells of 2 columns (excel)

Copy row and insert n times

Duplicate rows based on cell value

Similar discussions

Subscribe To Our Newsletter!