pivot tables have numeric output, they won't put out text
if I am reading your table correctly

"Rookie_User" wrote:

I have three columns.
A - Variant
B - Feature
C - Option

You will have one variant (unique) on the left side; features across the top
and options in the middle as content. There are multiple features and
options, but an equal amount. My data just shows 1's in the middle as
content and not the value of the option -- does anyone know why?

A B C
cpva feature option
488761 upholclr 61201833
488761 fdnprc fdnprc9
488761 rearmt -
488761 pkg std