Excel Power Query shift to the right

[menor59]

Hello alll,

Sorry for the silly question...new to Excel Power query. How do i get the following result please?? I attached a sample

 

[alansidman]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Column1"}, {{"Data", each _, type table [Column1=text, Column2=number]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Data], "Index",1,1)),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Data"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Column2", "Index"}, {"Column2", "Index"}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Expanded Custom", {{"Index", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Expanded Custom", {{"Index", type text}}, "en-US")[Index]), "Index", "Column2")
in
    #"Pivoted Column"

 

[menor59]

Thank you Sir!!!

 

[alansidman]

You are welcome.

 

[smozgur]

Thank you Sir!!!

The confirmed answer post has been marked as the solution. In your future questions, please mark the post as the solution that answered your question as it will help future readers. No further action is required for this thread.