Every month I have 2-5 million records csv files to filter & pivot.
Excel 2010/2013 can't open anything above 1 mil lines.
Does delimit do pivoting? The csv contains various security
event signatures, so I'll need to get a count for each event
plus pair up source & destination IP addresses for each event
& get a count for each pair of IP addresses (of each event)
Doesn't have to be freeware but ideally less than US$30