Power Query question

[scott_86_]

Hi,

Can anyone help me out with some applied steps for the below? I've tried a mixture of transpose, promote first row to header, unpivot, etc; however, so far am not having any luck!

(Apologizes, I am unable to upload a mini-sheet due to my organisations restrictions).

In the sample data below, I am trying to achieve the following:

 

[scott_86_]

Should I be pasting your code straight it the formula bar? I'm still not having any luck. Probably something really simple I'm missing!!

The steps I am taking is:

1. Table1 data to PQ
2. Pasting in provided sample code
3. Still receiving the following error:

Expression.Error: A cyclic reference was encountered during evaluation.

The advanced editor shows the following:

let

    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type any}}),
    Custom1 = #table(List.FirstN(Table1[Column1], 3), List.Split(Table1[Column2], 3))

in

    Custom1

Screenshot of the error once code is pasted in:

 

[RoryA]

The last formula should be:

= #table(List.FirstN(#"Changed Type"[Column1], 3), List.Split(#"Changed Type"[Column2], 3))