Text field as values in pivot tables

I have which is currently in this format:

I want to create a visual that shows the data in this format instead:

Is it possible in QuickSight? I understand that we can’t use text fields as values in a pivot table but I was wondering if there’s any possible workaround.

I don’t think so there is any work around for this. You cannot render text fields as values.