Forum Moderators: open

Message Too Old, No Replies

Consolidation Of Keyword Lists - How to?

         

SubmissoR

7:44 pm on Dec 1, 2004 (gmt 0)

10+ Year Member



Does anyone have a technique for consolidating keyword lists so doubles do not appear?

engine

9:02 pm on Dec 1, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



Spreadsheets do the trick for me. Of course, it depends upon how many keywords you're working with.

SubmissoR

9:11 pm on Dec 1, 2004 (gmt 0)

10+ Year Member



Does anyone know how to do it in Excel?

roscoepico

9:14 pm on Dec 1, 2004 (gmt 0)

10+ Year Member



Data --> Filter --> Advanced Filter --> Check off "Unique records only"

Make sure you have a column heading, I usually use "kw" or something unique

growingdigital

3:44 am on Dec 2, 2004 (gmt 0)

10+ Year Member



I keep mine in a database. I set the keyword as the Primary key. This prevents duplicates.

Vrindavan

1:37 pm on Dec 2, 2004 (gmt 0)

10+ Year Member



is it put two keyword lists under the same column
before running this command?

growingdigital

5:51 am on Dec 10, 2004 (gmt 0)

10+ Year Member



Yes. In SQL you can just use SELECT DISTINCT * FROM TABLE NAME.