•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can I consolidate this info into one row per activity
Our take
Are you struggling to consolidate your data into a single row per activity? If you’re familiar with PowerQuery and Macros, you have powerful tools at your fingertips to automate this process efficiently. By applying these techniques, you can transform messy data into a clean, organized format with just three columns: Date, Description, and Amount. This not only streamlines your workflow but also enhances data analysis. Continue reading to discover step-by-step methods that will simplify your data management and boost your productivity.
How can I automate something like this so that each item is one one row, 3 columns? I know PowerQuery and Macros.
| Date | Description | Amount |
|---|---|---|
| 2/1/2026 | It was the best of times. | 123.45 |
| It was the worst of time. | ||
| 2/2/2026 | The quick brown fox | 67.89 |
| jumped over the lazy rabbit | ||
| 2/3/2026 | Happy Birthday | 158.8 |
| 2/4/2026 | Merry Christmas | 250.11 |
| 2/5/2026 | Happy New Year | 19.85 |
| 2/6/2026 | I pledge allegiance | 428.94 |
| to the flag | ||
| of the United States of America | ||
| 2/14/2026 | Happy Valentines Day | 855.65 |
[link] [comments]
Read on the original site
Open the publisher's page for the full experience