•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
#rows.com