I'm trying to create a pivot table where one of the row fields is a
combination of default text and additional text. I would like to group
all the rows with the same default text together as one row value. is
there a way to do this?

for example

do not batch - broken
do not batch - pending
do not batch - missing documents
batched
pending
whatever

I would like all the lines that begin with do not batch - to be grouped
as one.. kind of like using a wildcard do not batch - *

is this possible?