Power Query to Transform Table Without Headers

[legalhustler]

Hello,

I want to transform this table to one row without any headers. How can I transform this table

Refresh Date

6/13/2024

to this:

Refresh Date

6/13/2024

If I unpivot the table it'll create a Attribute and Value headers, and in the next step if I promote the first row as headers it'll seem like it will work, but when I load it to my Excel workbook it loads it as a table like how I want it but there is a row below with no data since there were zero rows loaded. Any help is appreciated

 

[AlienSx]

Don't promote first row. Load table to Excel sheet, open menu Table Design and uncheck Header Row in Table Style Options section.

 

[legalhustler]

Don't promote first row. Load table to Excel sheet, open menu Table Design and uncheck Header Row in Table Style Options section.

Ah! I forgot about that option. Thank you!!