Consolidation Of Keyword Lists - How to?

[SubmissoR]

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

[engine]

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

[SubmissoR]

Does anyone know how to do it in Excel?

[roscoepico]

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

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

[growingdigital]

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

[Vrindavan]

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

[growingdigital]

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