auto update of weekly report into another table layout

Hi everyone

I receive a massive table every week of different categories of products sold in the previous week. The product categories are always the same and they are lined by row ie A1 cell product name ABC, B1 cell amount sold in $. A2 cell is product DEF and so on.

Question is how i can another table which rearranges the product category to A1 cell as product ABC and B1 cell is DEF. The $ for ABC is in A2 and $ for DEF is in B2. As there are more than 100 products which i need to change every week to this new table how can do this every time my weekly report comes in?

Thanks on advance

KL

attach a sample in excel format with a sample input and the expected output to facilitate us formulating the solution.