Matching multiple cells and printing info to a cell based on the matching

[Lassegund]

Hi

I am currently in the process of making a spreadsheet that will rank our sellers sales numbers for the month and I have run into some issues.
What I have is a list of sellers, with the item they sold and the number of items sold. Seller ID is in Column A, itemcode is in column B and amount sold is in Column C. This is not sorted in any particular way and each seller appears multiple times. (Once for each item sold)
What i want to do is create a formula that will search for a seller then find the products that seller sold and then display the total number for each item.
For example:

      **Seller      Item       Qty**

         Seller 1    Laptop     1
         Seller 2    Laptop     1
         Seller 3    Phone      1
         Seller 4    TV         1
         Seller 1    Laptop     2
         Seller 3    Phone      1
         Seller 2    Laptop     1
         Seller 1    TV         1

Result in output:

                            Laptop     Phone      TV
            Seller 1          3          0         1
            Seller 2          2          0         0
            Seller 3          0          2         0
            Seller 4          0          0         1

I have tried playing around with INDEX and VLOOKUP, but I have not had any luck. How can i solve this?

Thanks in advance.

[karolus]

Hallo

goto →Data→Pivottable....
drag and drop Seller into row-field
drag and drop Item into Column-field
drag and drop qty into Data-field
hit ok

[Lassegund]

That worked perfectly, thanks!

[JKEngineer]

@lassegund If it worked perfectly, you really should click the check mark to show this is an answer.