Hello,
I hope there is someone out there that can help me with this issue I'm having.... so here is my problem:
I work for an internet marketing company and I need to be able to take a list of customers and their keywords that display horizontal in multiple columns and transpose that information into 2 vertical columns. I have attached a file with two tabs; one showing how the data comes out of the database and the other showing how I need the data to appear.
For example this is how my data looks directly from the database:
Customer ID Keyphrase 1 Keyphrase 2 Keyphrase 3 Keyphrase 4 Keyphrase 5
96613 Pet services Groomer Dog sitter cat sitter pet grooming
96614 plumber plumbing HVAC leaky sink plumbing repairs
This is how I need the data:
96613 Pet services
96613 Groomer
96613 Dog sitter
96613 cat sitter
96613 pet grooming
96614 plumber
96614 plumbing
96614 HVAC
96614 leaky sink
96614 plumbing repairs
I'm hoping that someone can help me out with a formula that I can use to take thousands of customers and their keyphrases and transpose the data into 2 vertical columns.......
Thank you so much!!!
Bookmarks