append Multiple CSV then apply conditioning format to new sheet

[jasonpeel]

Hi All,

New to excel so not sure the title makes sense.

Basically I need to import multiple csv files, append the data and then apply some formatting to it that will recognise that the next row contains details about the same contact. The output needs to go to a new sheet where the details are placed not in columns but rows.

SO

NAME | BROCHURE | QUESTIONS | ANSWERS
jason BIKE
jason CLOTHING
jason WHAT COLOUR BLACK
jason WHAT SIZE 500cc
ian BIKE
ian WHAT COLOUR RED
ian WHAT SIZE 600cc

This needs to become

NAME | BROCHURE 1 | BROCHURE 2 | QUESTION 1 | ANSWER 1 | QUESTION 2 | ANSWER 2
jason BIKE CLOTHING WHAT COLOUR BLACK WHAT SIZE 500cc
ian BIKE WHAT COLOR RED WHAT SIZE 600cc


this file is then going to be imported in to a CRM package which is why there is a need to make the changes.

thanks in advance

Jason

 

[BrianB]

Perhaps my code here will help.

http://www.mrexcel.com/forum/showthread.php?t=140187

 

[jasonpeel]

many thanks will give it a good look!!

Jason