A B D
Company2 Q1:R1 Executive:R1
Q2:R2 Sales:R2
Q3:R3 Tech:R3
Q4:R4 CEO:R4
Q1:R1 Executive:R1
Q2:R2 Sales:R2
Q3:R3 Tech:R3
Q4:R4 CEO:R4
Q1:R1 Executive:R1
Q2:R2 Sales:R2
Q3:R3 Tech:R3
Q4:R4 CEO:R4
Q1:R1 Executive:R1
Q2:R2 Executive:R2
Q3:R3 Sales:R3
Q4:R4 Tech:R4
Company2 Q1:R1 CEO:R1
Q2:R2 Executive:R2
Q3:R3 Sales:R3
Q4:R4 Tech:R4
Q1:R1 CEO:R1
Q2:R2 Executive:R2
Q3:R3 Sales:R3
Q4:R4 Tech:R4
Q1:R1 CEO:R1
Q2:R2 Executive:R2
Q3:R3 Executive:R3
Q4:R4 Sales:R4
Q1:R1 Tech:R1
Q2:R2 CEO:R2
Q3:R3 Executive:R3
Q4:R4 Sales:R4
Company3 Q1:R1 Tech:R1
Q2:R2 CEO:R2
Q3:R3 Executive:R3
Q4:R4 Sales:R4
Q1:R1 Tech:R1
Q2:R2 CEO:R2
Q3:R3 Executive:R3
Q4:R4 Executive:R4
Q1:R1 Sales:R1
Q2:R2 Tech:R2
Q3:R3 CEO:R3
Q4:R4 Executive:R4
Q1:R1 Sales:R1
Q2:R2 Tech:R2
Q3:R3 CEO:R3
Q4:R4 Executive:R4
Above is the 3 columns I have in the Excel file: For proper formatting Excel file "Excel_Challenge" is attached with this post.
I have created a sample but actual file is too big.
Column 1st is : Company Name
Column 2nd is : Response for Each Question
Column 3rd is: Role for each response of each question.
My challenge is to arrange in a tabular format where for Each Company I have separate columns(2 columns). 1st column will say Each Question:Response for that company 2nd column will say Role:Response for Each Question for Each company. Now this two column will be for each question I have:
So output should look something like this:
First Column Second Column Third Column Second Column Third Column Second Column Third Column Second Column Third Column First Column Second Column
Company1 Q1:R1 Executive:R1 Q1:R2 Sales:R2 Q1:R3 Tech:R3 Q1:R4 CEO:R4 Q2:R1 Executive:R1
Company2 Q1:R1 Executive:R1 Q1:R2 Sales:R2 Q1:R3 Tech:R3 Q1:R4 CEO:R4 Q2:R1 Executive:R1
--------------------
---------------------
So there are 2000 companies and for each company there are 20 questions and for each questons there are 5 responses and for each response there is specific role.
I have also attached the "Output_Excel Challenge" file so that you will get the idea how the final output should look like.
Please let me know ASAP if anyone has any idea how to achieve this output.
thanks
Nanic
Bookmarks