Pivot - move row to column (text sums)

[Camp2-2]

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?

thank you. Grateful for your assistance.

[Camp2-2]

looks like my pic didnt post. posting again:
Untitled.jpg

[MarvinP]

Hi Camp2,

Pivot Tables want the "Values" column to be numbers. You need to sort and/or filter your table in the correct order and then group the data using the outline tool in the Data Tab.

[Camp2-2]

Hi, it looks like I have found the answer here:
on mrexcel.com [slash] excel-tips[slash]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.