Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Narendra Boga Narendra Boga is offline
external usenet poster
 
Posts: 22
Default MULTIPLE ROWS IN TRANSPOSE

Hi alll......

a small doubt...
I have a excel with date in different rows sequentially like..

A B C
1 12 13 14
2 15 16 17
3 18 19 20

If I arrage all the numbers in one column in "A". I use
pastspecial-transpose.
This is done only one row at a time. I need to transpose all at once in a
single column, like..

A
1 12
2 13
3 14
4 15
5 16
6 17
7 18
8 19
9 20

Pls help me... I have bulk data to arrage in one coumn.

thanks
Narendra


  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default MULTIPLE ROWS IN TRANSPOSE

You might do better if you ask in an Excel forum. This one's for Word!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Narendra Boga wrote:
Hi alll......

a small doubt...
I have a excel with date in different rows sequentially like..

A B C
1 12 13 14
2 15 16 17
3 18 19 20

If I arrage all the numbers in one column in "A". I use
pastspecial-transpose.
This is done only one row at a time. I need to transpose all at once
in a single column, like..

A
1 12
2 13
3 14
4 15
5 16
6 17
7 18
8 19
9 20

Pls help me... I have bulk data to arrage in one coumn.

thanks
Narendra



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
delete multiple rows wjh59 Microsoft Word Help 5 March 18th 13 09:18 AM
shortcut key to transpose dancenshout2002 Microsoft Word Help 1 April 21st 07 01:08 PM
is there a way to keep multiple table rows together? NU Tables 2 February 15th 07 03:05 PM
macro to transpose characters Elizabeth Microsoft Word Help 3 September 24th 06 02:13 PM
Can I Transpose a Word table? Ed Tables 1 January 26th 06 02:33 PM


All times are GMT +1. The time now is 04:00 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"