LinkBack URL
About LinkBacks
I receive a workbook weekly that has an individual row for each size. I need to take that and create one row and provide a count for each size.
What would be the easiest solution to go from my "Received" worksheet to my "Desired" workshet?
I receive a workbook weekly that has an individual row for each size. I need to take that and create one row and provide a count for each size.
What would be the easiest solution to go from my "Received" worksheet to my "Desired" workshet?
A simple pivot table should do - see attached.
Rory
How do you keep the data in the pivot table looking like that? This is what happens when I create a pivot table which makes the data unusable almost.Originally Posted by rorya
You have an error in your result...2318 has a boy entry of small...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
@sintek - that is amazing, and FAST!
If I need to add sizes to the Size Array, would any of the other code need to be modified?
Add as required and change all 10's to output column size...
What does the 10 represent?
See below...10 columnsoutput column size...
Untitled.png
If you add XS then 11 columns...etc etc
Last edited by sintek; 02-02-2021 at 12:50 PM.
Change the layout to Tabular, turn off sub totals, and turn on the option to repeat all item labels.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks