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
Tweetdeck larger columns - Guide
Display two columns in data validation list but return only one - Guide
How to delete rows and columns in word - Guide
Excel insert multiple rows - Guide
Repeat rows in excel - Guide

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

How to add Rows automatically based on Cell Value In Excel?

Excel Macro/Code help: Creating sheet for each name in column of another sheet

Copy range data in a column to new column.

formula if you have credit in one column, debit in next column

Similar discussions

Subscribe To Our Newsletter!