Jan 20 2021 02:39 PM
So i need to consolidate data from a column on a different sheet to another. Essentially, i need this
animal | qty | date |
dog | 12 | Jan |
cat | 11 | Mar |
dog | 10 | jan |
mouse | 6 | Jan |
Turned into this:
animal | qty | date |
dog | 22 | jan |
cat | 11 | mar |
mouse | 6 | jan |
I'm trying to consolidate the columns on rules of category and date, while adding up the qty of the category.
Can anyone help me with this? I have spent the last 5 hours trying to code this out or create rules with an action button and have nothing to show for it.
Jan 20 2021 03:02 PM - edited Jan 20 2021 03:04 PM
@Noxie I think PowerQuery or inserting a Pivot Table would be a better option to group your data by the 'animal' column. Can share the workbook, removing any sensitive data
Jan 21 2021 08:22 AM
@adversi here is a file with data removed. i'm trying to consolidate qty by item number and date. So all items that falls in january under item number 12345 would sow as a single row. Any ideas? I've tried using pivot tables but im making this for someone else, and requiring them to count is not realistic... I highlighted the fields as well
Jan 27 2021 06:18 PM
@Noxie Apologies for the delay -- a Pivot Table should be able to do this for you. See attached a sample workbook