How to get the Pivot table to show text of data and not sum/count values?

The technique is not obvious. Here are several articles that describe a couple of different ways.

.

Text Values- Displaying Text Values In Pivot Tables Without VBA (Conditional Formatting, 3 text values)
https://chandoo.org/wp/displaying-text-values-in-pivot-tables-without-vba/
Pivot Tables take tables of data and allow the user to summarise and consolidate the data at the same time. This is a great and very fast method of analysis but is restricted to handling mathematical functions on the value field resulting in numerical summaries.
It is possible to combine Custom Number Formats with the Pivot Table to produce Text based answers.
.

Text Values- A trick to Pivot text values                   2018 04 30
https://chandoo.org/wp/pivot-text-values/
https://assets.chandoo.org/wp/wp-content/uploads/2018/04/pivot-text-data-example.png

https://youtu.be/iZo5k_L8_RI

Text Values- Emulate Excel Pivot Tables with Texts in the Value Area using Formulas     2011 06 27
https://www.clearlyandsimply.com/clearly_and_simply/2011/06/emulate-excel-pivot-tables-with-texts-in-the-value-area-using-formulas.html
Pivot Tables are probably the most powerful built-in data analysis feature of Microsoft Excel. With only a couple of mouse clicks, you can summarize and analyze your data from different perspectives. Well, I do not want to carry coals to Newcastle. I am sure you know all about the power of Pivot Tables.
However, there is one thing you can’t do with Pivot Tables: create a cross-tabular view with texts in the value area.
Assume you are managing a project and you have a list of project risks. The table includes the descriptions of the risks and you classified each of them using different categories like the risk impact (high, medium, low), the probability (very high, high, medium, low) and maybe the type of the risk, the subproject or the name of the responsible project member. You may be interested in a cross-tabular view of your risk list with e.g. the impact in the rows, the probabilities in the columns and maybe the option to filter the view by a third category like the risk type.
At first sight this looks like the perfect use case for Pivot Tables, but a Pivot Table aggregates data, i.e. Pivot Tables always have numerical results in the value area. In other words, all you can show in the value area is the count of risks for each combination. But what if the count is not enough and you prefer seeing the description of all risks for all combinations of impact and probability?
.
Emulate Excel Pivot Tables with Texts in the Value Area using VBA   2011 07 30
https://www.clearlyandsimply.com/clearly_and_simply/2011/06/emulate-excel-pivot-tables-with-texts-in-the-value-area-using-vba.html
The recent post showed a way how to create a Pivot Table lookalike crosstab with texts in the value area.
However, due to the fact that it was restricted to Excel formulas, the approach came with a couple of drawbacks. Using formulas forces you to define the layout and the size of the crosstab in advance in a static structure. It goes without saying that this considerably limits the usability in real life.
Without VBA, there is no way out. However, some VBA helps to overcome almost all of the disadvantages of the formula based approach. Today’s post is the announced follow-up: it describes how to use VBA to emulate a Pivot Table lookalike crosstab with texts in the value area, as always including the Excel workbook for free download.
.

Text Values- Pivot Table Text Values  
https://www.contextures.com/pivottabletextvalues.html
Usually you can only show numbers in a pivot table values area, even if you add a text field there. By default, Excel shows a count for text data, and a sum for numerical data.
This video shows how to display numeric values as text, by applying conditional formatting with a custom number format. The written instructions are below the video.
.  *  Manual Conditional Formatting
.  *  Macro Conditional Formatting
.

Text Values- Pivot Table With Text in Values Area  2018 07 10
https://www.mrexcel.com/excel-tips/pivot-table-with-text-in-values-area/
Traditionally, you can not move a text field in to the values area of a pivot table.
However, if you use the Data Model, you can write a new calculated field in the DAX language that will show text as the result.
.

Create a Pivot Table from Text file in Excel?
https://www.extendoffice.com/documents/excel/5324-excel-pivot-table-from-text-file.html
Normally, Pivot Table is created based on the data in an existing worksheet. However, do you know how to create a Pivot Table from a Text file in Excel? This article will show you a method of creating a Pivot Table from a Text file in Excel.
.

Emulate Excel Pivot Tables with Texts in the Value Area using VBA   2011 06 30
https://www.clearlyandsimply.com/clearly_and_simply/2011/06/emulate-excel-pivot-tables-with-texts-in-the-value-area-using-vba.html
How to create a Microsoft Excel Pivot Table lookalike Crosstab with Texts in the Value Area using VBA
Today’s post is the announced follow-up: it describes how to use VBA to emulate a Pivot Table lookalike crosstab with texts in the value area, as always including the Excel workbook for free download.
.

VBA-