How to Duplicate a Query in Power Query
Sometimes you need the same data shaped two ways: one row per category, and one row per category manager, for example. Duplicate copies a query with all its steps, so you can change the copy without touching the original. Here's how, and when to use Reference instead.
