Power Query Group by column

[kcmuppet]

I'm struggling with what I think must be a simple thing for power query:

I'm trying to transform data as follows, but can't work out whether I should be using Group by or pivot

From this:				To this:
Column1.2	Column2	Q		Q	Category	Question
Category	General	Q01		Q01	General	Question Text 1
Question	Question Text 1	Q01		Q02	General	Question Text 2
Category	General	Q02		Q03	Key	Question Text 3
Question	Question Text 2	Q02		Q04	Key	Question Text 4
Category	Key	Q03
Question	Question Text 3	Q03
Category	Key	Q04
Question	Question Text 4	Q04

Here is the data for the starting table:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wck4sSU3PL6pU0lFyT81LLUrMAbICDQyVYnWilQJLU4tLMvPzQEJQpkJIakWJgiGSIhwmGOE3wQhJEZIJ3qmVYAlj/LqNkRRh0W2CX7cJTFEsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1.2 = _t, Column2 = _t, Q = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1.2", type text}, {"Column2", type text}, {"Q", type text}})
in
    #"Changed Type"

 

[RoryA]

It would be a pivot on the first column:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wck4sSU3PL6pU0lFyT81LLUrMAbICDQyVYnWilQJLU4tLMvPzQEJQpkJIakWJgiGSIhwmGOE3wQhJEZIJ3qmVYAlj/LqNkRRh0W2CX7cJTFEsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1.2 = _t, Column2 = _t, Q = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1.2", type text}, {"Column2", type text}, {"Q", type text}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column1.2]), "Column1.2", "Column2")
in
    #"Pivoted Column"

 

[kcmuppet]

It would be a pivot on the first column:

Thank you.

(I was getting stuck with which column to select before clicking on Pivot Column in the ribbon. In case it helps anyone else here, it seems to be:

First select (click on) the the column containing the names that you want to turn into columns - in my case Column1.2
Then
Click Transform > Pivot Columns
Make sure the Values Column is the one that you want to keep as one per row
Click Advanced options
Select Don't Aggregate

 

[RoryA]

You don't really need to select the relevant column first since you can just select it in the dropdown in the dialog. I should have mentioned the 'don't aggregate' part though!

 

[kcmuppet]

You don't really need to select the relevant column first since you can just select it in the dropdown in the dialog. I should have mentioned the 'don't aggregate' part though!

I found it didn't produce expected results unless I selected the column first.
For example If select this column:

and then still select correct pivot like this:

... I get this:

 

[RoryA]

Sorry - I must still be half asleep. You do have to select the pivot column first since the dropdown is for the values column.