with Table.PromoteHeaders
Code:
let
Source = Excel.Workbook(File.Contents("(path_to_the_file)\fakedata-0p7sxQX3Zv8cX2nyJaCYn.xlsx"), null, true),
#"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet" = Source{[Item="fakedata-0p7sxQX3Zv8cX2nyJaCYn",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet", [PromoteAllScalars=true])
in
#"Promoted Headers"
without Table.PromoteHeaders
Code:
let
Source = Excel.Workbook(File.Contents(("(path_to_the_file)\fakedata-0p7sxQX3Zv8cX2nyJaCYn.xlsx"), true, true),
#"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet" = Source{[Item="fakedata-0p7sxQX3Zv8cX2nyJaCYn",Kind="Sheet"]}[Data]
in
#"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet"
one line less and the effect is the same
name |
phone |
email |
address |
postalZip |
region |
country |
list |
Porter Franklin |
(625) 763-3454 |
urna.nec@protonmail.net |
949-736 Vitae St. |
16112 |
Lipetsk Oblast |
Nigeria |
11 |
Kasimir Ramirez |
(394) 402-7467 |
ante.lectus@outlook.couk |
Ap #611-325 Lectus Ave |
60746 |
Zuid Holland |
Austria |
7 |
Darius Stone |
1-184-757-7028 |
ipsum.dolor@protonmail.net |
P.O. Box 830, 967 Orci Rd. |
30546 |
Madhya Pradesh |
China |
3 |
Linus Jarvis |
1-839-469-3822 |
feugiat.metus@outlook.edu |
Ap #965-6264 Suspendisse Road |
05-958 |
South Island |
Chile |
1 |
Bookmarks