Best Practice with Excel - Unpivot columns with Power Query

One of the most complex task to do in Excel is to unpivot columns. Fortunately, now with Power Query, you can do this task with just one action. Discover the trick in this video.

[imanmoghimi]

thank you sir. very helpful and practical. please put the example file in description to use it as practice

[reng]

What happen if the same source table now is showing more years-months( this means more columns), after you have previously unpivoted through Power Query? How to skip the problem of adding more columns in the source table that this produce that the query does not work propoerly due tothe situation described above?

[cargouvu]

Thanks... I'm getting a lot of errors when I unpivot. How do I prevent them?