1 min readfrom 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
submitted by /u/Trust_Issues2278
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with