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
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,816
Messages
5,513,550
Members
408,957
Latest member
Jcoverick

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top