Transposing Data into one list

I have some data in columns with a campaign name, next row group name, further down the page some keywords that I need changing into rows on a new sheet.

Transpose doesn't work because it puts it all in one row and I need the first 2 rows to be repeated for every keyword, there can be upto 50 columns with this format that all need changing over. i.e

Campaign
Group


keyword1
keyword2
keyword3

becomes

Campaign Group Keyword1
Campaign Group Keyword2
Campaign Group Keyword 3

Thanks!

Dear boolucy173

Please check, hope this will help you out on your way.

Regards...
...Marc
The Stupid Common Guy

Thanks for having a go, its not quite the result I was looking for though, I need it to automatically start picking up the next column and list them below. I've included an example of what this will look like on the tab entitled "results".

Thanks for your help!

Hello Aussie

Something like this????

Thanks Marc but the lists have varying numbers of keywords so I think it needs to be vba, I'm almost there with the attached file but it doesn't pull the campaign name. Getting very frustrating!

I forgot to mention, on the atachement above its the tab DS Keywords which has the macro I have built and its building onto that tab and Adwords Keywords Tab. It pulls the keywords successfully but not the campaigns or adgroups.


Lucy