I extracted data from another database. I want to make this data in pivot table formatting, which means fill Country and Product Column in every row so I can do analytics by country or by product type. There are 15000 rows. How can I do it using Macro?
<tbody>
</tbody>
B | C | D |
Country | Product | Product Type |
QATAR | Generators | Type 1 |
Type 2 | ||
Type 3 | ||
Leads | Type 1 | |
Type 2 | ||
Type 3 | ||
Type 4 | ||
Other | Type 1 | |
Type 2 | ||
Type 3 | ||
BRAZIL | Generators | Type 1 |
Type 2 | ||
Leads | Type 1 | |
Type 2 | ||
Other | Type 1 | |
Type 2 | ||
Type 3 | ||
Type 3 |
<tbody>
</tbody>