Add Headers

Hi,

Using Power Query in Excel

I imported data from an Excel file.

I noticed Headers are stacked in the 8th column in rows 1:4, other Headers are missing.

So I thought I would create a separate Table with Headers, Transpose the original Table, Add a Column, Merge the 2, Transpose back.

The first Transpose is taking a long time, I just get a spinning wheel.

Is there a faster way to add the Header Row?

Thanks,

-w