Merging rows and using row values as both column headers and row values

[mterry]

I have a table that has a column filled with questions, and another column with applicable respoonses to those questions. I'm hoping I can transform this table using Power Query so that each question is a column header and the value in that column is the response. A sample of the table as-is now and what I'd like for it to look like is posted below:

Table now:

Company	Question	Response
Acme	Question 1	Yes
Acme	Question 2	No
Acme	Question 3	50
Acme	Question 4	Blue

My desired result:

Company	Question 1	Question 2	Question 3	Question 4
Acme	Yes	No	50	Blue

[Akash_Varuna]

Hi @mterry , Could you please try this 

• Select "Company" as the grouping column, "Question" as the column to pivot, and "Response" as the values.
• Go to the "Transform" tab and click "Pivot Column."
• In the dialog, set "Values Column" to "Response" and "Column to Pivot" to "Question."
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance

[mterry]

Thanks for the response - I didn't get a chance to try as the previous response worked. 

[ronrsnfld · Accepted solution]

Just Pivot with no aggregation

Table.Pivot(#"Previous Step", List.Distinct(#"Changed Type"[Question]), "Question", "Response")

[mterry]

Thanks this worked!