Concatenating multiple column values with nulls

[jrkmorgan]

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]

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. 

[jrkmorgan]

I missed the isEmpty filtering. Thanks! Long day already!