Concatenating multiple column values with nulls

Question

I need to concatenate the following columns to have an end result of

Column 1        Column 2

API value1        QRA-ENLPI-KEA-CWSET-CWSH-DOMP-RESV

API value2        QRA-ENLPI-KEA-RESV

I've tried the methods located in the community via search, but it's not coming out quite right, so I'm doing something wrong possibly. When the column is blank or null it needs to skip it in the concatenation. I keep ending up with the headers concatenated so every API entry looks exactly the same.

What am I missing?

Luke_C · Accepted Answer

Hi @jrkmorgan

If you can attach the sample data instead of a screenshot it may be easier to mock something up, but I'd suggest:

1. Transpose the 7 columns (QRA through RESV)

2. Filter out blank/empty values

3. Use the summarize tool to group by the API value and concatenate the other values.

jrlindem · Accepted Answer

Yep, using IsEmpty() or IsNull() can be really useful to removing out those pesky blank values.  And since you're doing this for each cell, not entire columns, this would be a great method to use.  -Jay