C
Carl
I have 80000 lines of data spread split evenly over 2
worksheets. The worksheet(s) looks as so:
Product Buyer Seller Qty
P1 Frank Jim 10
A2 Jim Bob 20
A3 Mark Frank 10
P2 Jim Frank 30
P1 Jim Frank 25
I would like to tabulate by Customer (Frank/Jim/Bob/Mark)
how much of each product (P1/A2/A3/P2/P1) was traded ?
For example, for Frank the result would be:
A2 A3 P1 P2
Frank 0 10 35 30
What would be my best approach ?
worksheets. The worksheet(s) looks as so:
Product Buyer Seller Qty
P1 Frank Jim 10
A2 Jim Bob 20
A3 Mark Frank 10
P2 Jim Frank 30
P1 Jim Frank 25
I would like to tabulate by Customer (Frank/Jim/Bob/Mark)
how much of each product (P1/A2/A3/P2/P1) was traded ?
For example, for Frank the result would be:
A2 A3 P1 P2
Frank 0 10 35 30
What would be my best approach ?