Removing Nulls

[romachainani]

This is what I have:

Sum Values	Sum Sum Values
[Null]	3345
12345	[Null]

This is what I need:

Sum Values	Sum Sum Values
12345	3345

I basically need to remove those nulls. It's a simple ask, but not sure why I can't get it right now. Ty for the help!!!

[Prometheus]

@romachainani I used a Transpose tool to put all the values into one column -- Value. Then the Filter tool to not allow nulls to pass. Then finished with the Cross Tab tool to repivot the data.

 

 

 

[binuacs · Accepted solution]

@romachainani Another option with the summaries tool