good evening to all .. i little help here please.............


i have a text file with 2 columns... country and product.... i need to create a pivot table with this data to look like the output below :

 Uk  prodA  10
     prodB  20
     prodC  130
 US  prodA  101
     prodB  202
     prodC  1303

First column is country, second column is product and third is the mount of each product per country... Very simple to be achieved with a pivot table.. but...

Now comes the challenge: The text file has 300.000 records....does anyone has a clue how this could be done on Excel... or any other product ?