Clean Messy Merged-Cell & Multi-Header ERP Spreadsheets with Excel Power Query + AI
Stuck with "human-style" spreadsheets full of merged cells, multi-row headers, and embedded subtotal rows? Use AI + built-in Excel Power Query to unpivot and clean them automatically.
CORE TOOLS
Excel / WPS Built-in Power Query, DeepSeek / Claude
BEST FOR
Accountants, HR specialists, supply-chain planners, sales ops
REQUIREMENTS
Microsoft Excel (2016+) or modern WPS Spreadsheets
✦ WHY THIS WORKFLOW
Power Query is already built into Excel yet vastly underused. Pairing it with AI-generated M code automates ugly spreadsheet cleanup without installing Python.
I have a messy Excel report with the following structure:
[Describe layout: e.g., 3 title rows at top, merged cells in Columns A & B, two-row horizontal headers for Months + Plan/Actual, and embedded "Subtotal" rows]
Show me how to turn this into a clean, normalized flat table using **Excel Power Query** (no Python/VBA needed):
1) [Step-by-Step UI Clicks]: Exact order of operations in the Power Query ribbon (Fill Down, Merge Header Rows, Filter out Subtotals, Unpivot Other Columns);
2) [Ready-to-Paste M Code]: Complete Power Query M script I can paste into the `Advanced Editor` with comments.
Use Cases & Tags:
Unmerge and fill-down broken hierarchiesUnpivot wide monthly columns into tidy rowsStrip embedded subtotal and blank rowsAuto-combine 30 regional Excel files in a folder#power query
A viral multi-platform AI assistant and agent harness with 43k+ GitHub stars! AstrBot seamlessly connects mainstream chat networks (QQ, WeChat, Telegram, Discord, Feishu, DingTalk, Slack) to modern LLMs (DeepSeek, GPT-4o, Claude, Ollama). It features native multimodal support (voice input/output, image recognition), an expansive plugin ecosystem, and Model Context Protocol (MCP) compatibility. Complete with an intuitive web admin UI, long-term memory store, multi-agent routing, and one-click Docker setup, AstrBot empowers users to self-host a secure 24/7 autonomous copilot across all personal and community channels.
A viral automated daily newsroom framework with 8.6k+ GitHub stars! AIHOT solves information overload by autonomously monitoring Twitter/X trends, Weibo, XiaoHongShu, GitHub Trending, and custom RSS feeds. It uses local or cloud LLMs to deduplicate coverage, strip low-quality noise, score factual credibility, and distill the day's top stories into concise impact analyses. The framework automatically generates sleek, minimalist daily web digest pages and pushes instant briefings to Feishu, WeCom, Telegram, and email subscriber lists.
A viral open-source mobile automation project with thousands of GitHub stars! It achieves autonomous iPhone operation without jailbreaks, enterprise certificates, or intrusive MDM profiles. Using a $7 ESP32-S3 board: the host PC receives high-resolution, low-latency iPhone screen feeds via Apple AirPlay (the agent’s "eyes"), while a vision model computes coordinates and commands the ESP32 over serial to inject hardware-level USB HID multitouch and keyboard events (the agent’s "hands"). Perfect for automated QA, social workflows, and routine mobile tasks.
The proven infrastructure behind OpenAI's ChatGPT Advanced Voice Mode! LiveKit Agents is an open-source real-time multimodal agent framework with 15k+ stars. Slashes end-to-end WebRTC latency under 200ms; features millisecond Silero VAD for natural conversational barge-in interruptions; and seamlessly pipes streaming STT, LLM reasoning, TTS, and avatar video rendering into enterprise-grade conversational AI.
A viral multi-platform social extraction engine with 100k+ stars on GitHub! Agent-Reach gives AI agents eyes across the entire social web. Through a unified MCP server and CLI, agents can search, read, and extract posts, comments, and transcripts from Twitter/X, Reddit, YouTube, GitHub, Bilibili, and XiaoHongShu—with zero platform API fees and zero authentication headaches for automated social listening and competitor audits.
A viral GitHub #1 Trending breakthrough! DeerFlow 2.0 by ByteDance is an open-source SuperAgent harness that orchestrates sub-agents, memory, and sandboxes for long-horizon tasks. Overcoming single-agent context drift, DeerFlow coordinates specialized sub-agents with extensible skills and an asynchronous message gateway to handle complex research, autonomous coding, and data synthesis over minutes to hours.