Consolidate values

[Assamita]

Hello everyone.
I'm having troubles with a huge file I'm trying to reduce.
I have a list of almost 280k sales orders that it's slowing the file (and the whole computer) down a lot. For my purposes, I realized I can reduce that drastically by summing up the number of orders per month, instead of having one line per each single order.
My original idea was to use the consolidate button, but I haven't figured out how to properly use it, so my second option was to add a columns with a sumifs formula, and then delete duplicates. But it takes so long the file finally crashes.

The values are looking something like:

Country

Vendor

Sales order

Full Date

Month only

Number of invoices

<tbody>
</tbody>

I would need to group by month the number of sales orders per country per vendor (I hope I made myself clear).

Any ideas on how can I do it?
Thank you

 

[jbesclapez]

Can you send the file? Because I dont think we can help otherwise... it's too theoretical your problem. Sorry

 

[Assamita]

well, it's an 18Mb file, and it has sensitive data in it (it's a work file), so I'm afraid I can't. But I can copy the headers and make up one line, see if that could help.

Company code		Global Manufacturer (MD)	Local Manufacturer (MD)	L- Prod Hierarchy (MD)	Profit Center (MD)	Sales document	Sales order date	No of invoices	Month
0010		ACRONIS	ACRONIS	Acronis Lizenzen	Acronis	xxxxxxxxxxxx	30/05/2017	1	5

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Assamita]

Nevermind, I left it working and I've managed to do it. It took about 2 hours of computer time, but it's ok now.
Thank you