Add Headers

[tecumseh]

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

[tecumseh]

9,159 rows

[Ehren]

Right. But how many columns?

It would be great if you could share a set of files (without any sensitive info) that reproduce the issue.

[tecumseh]

8 columns x 9,159 rows

[Ehren]

Ok. That certainly doesn't seem like a data size that should cause issues when transposing.

Can you share more details? For example, it would be helpful if you could share the M formula text of your queries, or some non-sensitive sample files that reproduce the issue, or even screen shots or a recording of your queries and the slow performance.

Without more info, it will be difficult to provide any helpful advice.

[tecumseh]

Hi Ehren,

I'm guessing you mean the non-header table which contains 9,159 rows.

Thanks,

-w

[Ehren]

How many columns? I'm wondering if it's trying to transpose a huge number of empty cells.

[Ehren]

How many rows does the headers-only table contain before you transpose it?