How to concatenate a column of data into a comma seperated list. After you’ve finished your keyword research, you might want to paste the list of keywords back into AdWords as a comma separated list.

1/ open notepad 2

2/ paste in your column of data

3/ click ‘file’ anc change the ‘line endings’ to UNIX

4/ use ctrl + H to oopen find and replace

5/ input ‘\n’ in the search string box to find all line endings,  replace with ‘,’ in the replace with box.

6/ make sure the ‘Transform backslashes’ box is ticked

7/ click replace all

8/ remove whitespace as well using the remove whitespace function!