•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there a way to interlace columns in pivot tables?
I want a pivot table to have 2024 values and 2025 values, month by month. But instead of having all the 2024 month columns lumped next to each other and all the 2025 month columns lumped next to each other, I want them to interlace. So it would be Jan 2024, Jan 2025, Feb 2024, Feb 2025.
In the future, I’d like to have even more years interlace, not just 2024 and 2025.
How can I do this?
All of my data for both 2024 and 2025 are all in the same table.
[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
#pivot table
#interlace
#2024
#2025
#month
#columns
#values
#data
#table
#month by month
#years