Hello,
I need to create a matrix style table from my data set similar to this:
<tbody>
</tbody>
The product details fields are mostly text fields, so I ran into issues trying to do this with a pivot table. Does anyone know the best way to do this in Excel? Or is it even possible?
Thanks in advance!
I need to create a matrix style table from my data set similar to this:
Category | |||||
Sub Category | |||||
Product Name | Product Detail | Product Detail | Product Detail | ||
Product Name | Product Detail | Product Detail | Product Detail | ||
Product Name | Product Detail | Product Detail | Product Detail | ||
<tbody>
</tbody>
The product details fields are mostly text fields, so I ran into issues trying to do this with a pivot table. Does anyone know the best way to do this in Excel? Or is it even possible?
Thanks in advance!