Transform Table before expanding

[mduntley]

Trying to skip the first row and then make a header for the first row

let
    Source = #table({"Placeholder"}, {{"Something"}}),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Table.FromRecords({
    [Column1 = null, Column2 = null],
    [Column1 = "Color", Column2 = "Shape"],
    [Column1 = "Blue", Column2 = "Square"],
    [Column1 = "Black", Column2 = "Triangle"]
})),
    Custom1 = Table.TransformColumns(#"Added Custom",Table.PromoteHeaders(Table.Skip([Custom],1)))
in
    Custom1

Current

Book1
	A	B
5	Column1	Column2
6	null	null
7	Color	Shape
8	Blue	Square
9	Black	Triangle
10
Sheet1

Desired Table

Book1
	A	B
13	Color	Shape
14	Blue	Square
15	Black	Triangle
Sheet1

 

[JGordon11]

let
    Source = #table({"Placeholder"}, {{"Something"}}),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Table.FromRecords({
    [Column1 = null, Column2 = null],
    [Column1 = "Color", Column2 = "Shape"],
    [Column1 = "Blue", Column2 = "Square"],
    [Column1 = "Black", Column2 = "Triangle"]
})),
    Custom1 = Table.TransformColumns(#"Added Custom",{"Custom", each Table.PromoteHeaders(Table.Skip(_))})
in
    Custom1

 

[mduntley]

I want to ask a addition question related to this. I only want to the row where the color is Black