Trying to skip the first row and then make a header for the first row
Current
Desired Table
Power Query:
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 |
Last edited: