•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to handle data with uneven rows when you want to turn it to a pivot table?
Hi Everyone,
I have the highest sales amount for the month, and the salesperson who made that sale (e.g. $115.50 is the highest sale made in Jan 2025 - Joe made a $115.50 sale on some day in Jan 2025 and Stacy also did on some day in Jan 2025). What's the proper way/structure to turn this data into a pivot table with possible uneven row length for the salesperson? Should the sales person not be in rows but in one column - but I don't want them to add the 2 sales amount (made by 2 different salesperson together) in the pivot 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
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#Excel compatibility
#row zero
#pivot table
#uneven rows
#sales amount
#salesperson
#sales data
#highest sale
#data structure
#monthly sales
#data analysis