append Multiple CSV then apply conditioning format to new sheet

jasonpeel

New Member
Joined
Aug 6, 2010
Messages
2
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
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,613
Messages
5,832,707
Members
430,155
Latest member
spacedad41

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top