Changing Data To Make It Usable For A Graph

A very simple way to transform would be

Load the table into PQ without headers i.e. your headers will be Column1, Column2...

Transpose

Select first column, right click and remove all duplicates

Transpose

Promote headers

Below is the code which gets generated

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Transposed Table" = Table.Transpose(Source),
    #"Removed Duplicates" = Table.Distinct(#"Transposed Table", {"Column1"}),
    #"Transposed Table1" = Table.Transpose(#"Removed Duplicates"),
    #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table1", [PromoteAllScalars=true])
in
    #"Promoted Headers"