Jump to content

How do you stop Pivot Concatenations from including NULL values?

Luke Burston

Recommended Posts

I have String values in a column that sometimes may be NULL, and I want to Pivot the column into one cell, however if I have say "Red", "Blue", NULL, and "Green" the result turns out as "Red, Blue, , Green" Instead of "Red, Blue, Green".

There are values in other columns of that NULL row that need to be included in the data and so I can't just straight up delete the row, and I don't want to replace the NULL value with something else like "No Colour", I just want it straight up exclude it from being concatenated.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...