Move Row to Column in a Pivot

[pdvsa]

hello, I have a pivot and I do not like the format of it.

I want to move the the row for "description" (the red starred in the pic below) from the row to the column but when I do this it wants to sum this text field. How can I move the row to the column but make it display the text as it is?

Here is a link to the file on onedrive:

RowToColumn.xlsx

1drv.ms

the xl2bb software on the site seems to not work for me. thank you for your assistance.

 

[pdvsa]

Hi, it looks like I have found the answer here:
Pivot Table With Text in Values Area
you have to add a calculated field but when creating the pivot you need to click a special button "add to data table" and the formula to use is =CONCATENATEX(Values(Table1[your field]), Table1[your field], ", ")
seems very odd because I am not concatenating anything but it does work. I have tested it.

thank you.