I will consolidate, clean and transform messy data using excel power query

Here is what I can do for you:

• Import Data: From Web, Text Files, CSV, other Workbooks, or the current workbook.
• Combine Data:
• Combine all Excel files in a folder.
• Combine all CSV/Text files in a folder.
• Merge tables (like a VLOOKUP but better!).
• Clean & Transform:
• Split, Merge, and Filter Columns.
• Replace Values and Fill Down.
• Transpose and Group Data.
• Unpivot data (change columns to rows).
• Advanced Analytics:
• Add Index Columns, Custom Columns, and Conditional Columns.
• Use IF/OR/AND logic in queries.
• Automation: I will set up your queries so they update automatically when you add new data to your folders.

My Expertise:

I am proficient in the M Formula Language and can write custom functions to handle complex scenarios like extracting data based on user selection.