Forum Discussion
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...
8 columns x 9,159 rows
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.