•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#real-time data collaboration
#PowerQuery
#Macros
#automation
#data consolidation
#row
#columns
#amount
#date
#description
#Excel
#financial data
#analytics
#data entry
#data processing
#table