My power query editor freezes when adding a customized column

[Mar01]

My power query editor freezes when adding a customized column. Impossible to work!!! I could use a little help! 🙂 Thanks in advance.

[Mar01]

Hi!
The issue is that I got 4 excel files, I create a new table based on these 4 tables, I run transpose and then add a new custom column and....it crashes!!
1st: 

2nd: Transpose:

3rd: Add custom column: it crashes. Maybe it is amatter of size after transposing?

Many thanks in advance for your help!!!!

[v-xiaosun-msft]

Hi @Mar01 ,

I didn't reproduce your problem. Did you mean that the "advanced editor" button was grayed out and could not be selected after you created a custom column?

If convenient, could you please describe your issue more clearly and provide your steps (If you can provide a screenshot, it will be better.) in order that we can help you further more.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.