I have a list of data, that I have cleaned, but I need to organize it in a way that allows me to import it into a CRM.

I can't think ov a way to convert that data into a decent table other than a pivot table.

The problem is the pivot table doesn't allow for just showing text.

Any way to do this?

Here is an example of the data

| Column A | Column B |

Example Data: