Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
pintree3 pintree3 is offline
external usenet poster
 
Posts: 2
Default sorting partial rows & columns-preferably in 2 languages

I have 6 columns and about 100 rows
column 1 pinyin Chinese , -2 is its Chinese character and 3- its english
meaning
The same is repeated for columns 4,5,6.
How can sort / alphabetize only the 1st 3 columns, and then, separately the
next 3.
Something like this
1 2 3 - 1 2 3
a @ Money -- a % fire
b # Apple -- d & cats
c $ Coats -- f # bask

note that the first 3 columns are sorted according to the 1st column and not
the other 2
And the next set of 3 is also done so, independant of the other set.

One way I thought I could do so is to have 2 different tables side by side
(1 on the left 1 on the right) but I do not know how to do this.
It doesn't have to be Word it could be done in any other Office.
Also, ideally it would be nice to be able to sort it according to 3 rules
1 set sorting by its Pinyin
2nd set sorted by Chinese characters
3d set sorted by English words.

I wa sthinking Excel or a database programn may be better--but I would need
tio be held by the hand with exact instructions with these 2 sionce I do not
know them much.

Thank you

  #2   Report Post  
Posted to microsoft.public.word.tables
DeanH DeanH is offline
external usenet poster
 
Posts: 1,862
Default sorting partial rows & columns-preferably in 2 languages

Yes you can, select the columns you want to sort, if you are doing the whole
100 rows, run the mouse cursor over the top of the first row and you will see
an arrow pointing down, press the left-mouse button and hold, then select the
next two columns. Do your sort via Table, Sort, it will give you the options
about Header Row, and which column to sort by and Ascending or Descending.
Then repeat on columns 4-5-6.
Hope this helps
DeanH


"pintree3" wrote:

I have 6 columns and about 100 rows
column 1 pinyin Chinese , -2 is its Chinese character and 3- its english
meaning
The same is repeated for columns 4,5,6.
How can sort / alphabetize only the 1st 3 columns, and then, separately the
next 3.
Something like this
1 2 3 - 1 2 3
a @ Money -- a % fire
b # Apple -- d & cats
c $ Coats -- f # bask

note that the first 3 columns are sorted according to the 1st column and not
the other 2
And the next set of 3 is also done so, independant of the other set.

One way I thought I could do so is to have 2 different tables side by side
(1 on the left 1 on the right) but I do not know how to do this.
It doesn't have to be Word it could be done in any other Office.
Also, ideally it would be nice to be able to sort it according to 3 rules
1 set sorting by its Pinyin
2nd set sorted by Chinese characters
3d set sorted by English words.

I wa sthinking Excel or a database programn may be better--but I would need
tio be held by the hand with exact instructions with these 2 sionce I do not
know them much.

Thank you

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
two columns two languages rwbta Page Layout 3 April 7th 09 06:16 PM
Splitting Partial Rows Ed Sheehan Tables 4 July 23rd 06 08:14 PM
'Tables'- 2 columns,4 rows. Can you merge one column into 3 rows? CalMac Captain Tables 1 May 19th 06 03:27 PM
Sorting cells within multiple rows RFJ Tables 3 June 13th 05 02:41 PM
Sorting a table while keeping some related rows together Dan Corban Tables 7 January 20th 05 07:31 PM


All times are GMT +1. The time now is 08:58 PM.

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

About Us

"It's about Microsoft Word"