Sort a playlist by a key word

Hi using 2013
i tried to use sort tool
it worked partially or not at all
For exa
if i wanna sort the pl by artist
having
-47:The Beatles - I Am The Walrus
i use in field1 Word 2 and in field 2 text
it getting out with all "the " together
the prob is that some are written "the beatles" and some just " beatles"
would like to stick together all rows where is written " beatles"
some1 has a macro for that ?
thanks

Hi thanks
First to use what u sent 2 me i've to transfer a list in a word sheet to the source table
Ok i managed this but maybe cause the blank rows or some reason else it does not work
Second how can i specify the key word?
Third even if i succeeded to do it i've to transfer back to a word sheet without the table
sorry if it's too much

Hi thanks
First to use what u sent 2 me i've to transfer a list in a word sheet to the source table
Ok i managed this but maybe cause the blank rows or some reason else it does not work
Second how can i specify the key word?
Third even if i succeeded to do it i've to transfer back to a word sheet without the table
sorry if it's too much

Sorry did not find how to erase the doublon

edit second
delete text
type there : double post

Ok without shortcuts
here is a playlist
a raw 1 as it is played on media software

This is one after sorting [manually]

Originally Posted by sandy666

1. you want sort by artist (without "The")
2. do you need these numbers in front of ?
3. what means: sort by keyword ?

your second example is not sorted by A-Z

1 right
2 yes it's the row number of the media
3 keyword can be "young " and all the media including this word would be
a sorted first
b if there are many of them by ascending row 10 before 42 for example

So i'll be able to sort the rest of the list by another keyword
By the end i'll get a list of medias each row by a different artist

my second example shows groups of medias each one by a different artist
and the rest of the list is not sorted by row number cause i do this manually but i'd want to get them sorted not a..z but 1..2
sorry for my poor english

[QUOTE=sandy666;4758157]Ok, maybe this one is that what you want (if I understood well)

save word as text
copy list from txt file into excel
refresh query table
copy list from query table and paste into word as Keep Text Only

Thanks got it

One more thing....
refresh query table then use CustomFilter as filter for keyword(s) [there are many options]
if you want back to default list just refresh query table again (or clear filter)

Originally Posted by sandy666

You've Ex2013 and maybe you've add-in PowerQuery also so you can try this to solve your problem.
here is example

usage:

• add any title to source table
• click on result table and refresh

Hi i was away sorry
i just got what utried to say to me in this post above
i've not this add-in
i looked at a tutorial on u tube and found out where to get it
prob is i've not in the pack
So tried to dl it
need a 32 bit version to get it
i did dl the update
it said to me that it can do the update cause i've a version of 64 bit
too much for me
the fact is i can't use power query
sorry

It should start for downloading with 32-bit version PQ 32

i tried your link
that's what came about

Seems you MS Office is not updated
try here: SP2

Sorry the link u sent is for a 2010 version
actually i solved the prob
i quested Google about a version of PQ 64 bit and found it
i dl it and installed and it works now perfectly
this is an awsome tool really i think i've to learn it more to use it properly
thanks for your help