How do I get text in a pivot table in excel or google sheets

Question

I have a list of data that I have cleansed, but I need to arrange it so that I can import it into a customer relationship management system. Other than using a pivot table, I'm at a loss for how to make the data into a usable table. The pivot table has a limitation that prevents it from displaying text alone.

Any chance of doing this?

Answer 1

Try:

=QUERY(QUERY({Data!A:A, Data!Q:S}, 
 "select Col4,max(Col1) 
  where Col1 is not null 
  group by Col4 
  pivot Col2"), 
 "offset 1", )