Search : in
By :

Columns Into Rows

Last answer on Sep 17, 2009 3:24:08 pm BST Chris, on Jul 9, 2009 6:34:05 pm BST 
 Report this message to moderators

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.

Configuration: Windows XP Internet Explorer 7.0 MS Office 2007

Best answers for « Columns Into Rows » in :
Transforming columns into lines Show Transforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
How to turn a URL into a hyperlink ShowHow to turn a URL into a hyperlink If you are using PHP, there is a simple way to turn a URL into a hyperlink when inserting the address into your PHP document. This process is mostly used to ease the users' search of external websites or...
[Excel] Sorting rows only Show[Excel] Sorting rows only Microsoft Excel by default perform a sort on the columns (Data/Sort). To sort the data horizontally, just select the data to be sorted, then Data tab /Sort/ Options/ check the Sort Left to right box in the...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...

1

venkat1926, on Jul 10, 2009 1:02:50 am BST
  • +3

Use
edit-copy-edit-pastespecial-transpose

Reply to venkat1926

2

 Kat, on Sep 17, 2009 3:24:08 pm BST

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!

Reply to Kat