i need to show keywrod in rows against single url

Hi guys .... please find the attached file i hope i have explained well about my problem in the sheet .... please do resolve it asap....


i want to show keywords that are in column in a single row haveing same url

i.e.


What I have
url keywords
url1 a
url1 b
url1 c
url1 d
url1 e
url1 f
url2 aa
url2 bb
url2 cc
url2 dd




What i want
url1 a b c d e f
url2 aa bb cc dd



reply sooon

Heres a macro that should do the trick. Click the button in attached file.




guys help needed.xlsm

Hi man Thank you so much . It works ..