📘 How to Use This Power Query Script Library

This library is a curated collection of reusable Power Query (M) patterns designed to help analysts stop rewriting the same logic and feel confident they’re using proven approaches.

It is not a replacement for Power Query documentation or GitHub repositories — it’s a practical, task-focused reference for everyday work.

🔹 Who this library is for

This library is most useful if you:

• Use Excel or Power BI Power Query
• Regularly clean, combine, or prepare data
• Often repeat the same transformations
• Want clear guidance, not just raw code

It is especially aimed at:

• Business / data analysts
• Finance and operations teams
• Public sector / NHS analysts
• Consultants and PMs working with data

🔹 How each script is structured

Every script follows the same structure so you can quickly decide if it fits your problem:

• What this script does – plain-English outcome
• When to use / when not to use – avoids misuse