Excel Pivot Table with Text Values or Matrix?

[dani357]

Hello,

I need to create a matrix style table from my data set similar to this:

[TABLE="width: 600"]
<tbody>[TR]
[TD]Category[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sub Category[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Product Name[/TD]
[TD]Product Detail[/TD]
[TD]Product Detail[/TD]
[TD]Product Detail[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Product Name[/TD]
[TD]Product Detail[/TD]
[TD]Product Detail[/TD]
[TD]Product Detail[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Product Name[/TD]
[TD]Product Detail[/TD]
[TD]Product Detail[/TD]
[TD]Product Detail[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!

 

[Johnny Thunder]

I think you might have to elaborate further on this to get a better response. But I don't see the issue with pivot tables and text?

 

[Fazza]

Maybe a cross-tab query?
Searching should find a few old threads where I've described in the past.
Like https://www.mrexcel.com/forum/excel-questions/396182-pivot-table-text-values.html