•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query Start Year to Year convert
Hello Everyone. A monthly report is generated as shown on the left. I am hoping to use Power Query to adjust the columns as shown on the right so the total cost per year is easier to visualize. Is there a simple way to use PQ for this? It isn't too hard to manually filter and do this but I'd like to remove any manual steps if possible.
| Data | Desired Output | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Project Name | Project Start Year | Year 1 | Year 2 | Year 3 | Year 4 | Project Name | Project Start Year | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | |
| Alpha | 2024 | 1,000.00 | 600.00 | 200.00 | 0.00 | Alpha | 2024 | 1,000.00 | 600.00 | 200.00 | 0.00 | 0.00 | 0.00 | |
| Bravo | 2025 | 200.00 | 0.00 | 0.00 | 0.00 | Bravo | 2025 | 0.00 | 200.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Charlie | 2024 | 500.00 | 500.00 | 500.00 | 100.00 | Charlie | 2024 | 500.00 | 500.00 | 500.00 | 100.00 | 0.00 | 0.00 | |
| Delta | 2026 | 200.00 | 100.00 | 0.00 | 0.00 | Delta | 2026 | 0.00 | 0.00 | 200.00 | 100.00 | 0.00 | 0.00 | |
| Echo | 2026 | 1,500.00 | 1,000.00 | 500.00 | 250.00 | Echo | 2026 | 0.00 | 0.00 | 1,500.00 | 1,000.00 | 500.00 | 250.00 | |
| Foxtrot | 2025 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | Foxtrot | 2025 | 0.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 0.00 |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#Power Query
#Project Name
#Project Start Year
#monthly report
#total cost