Removing Nulls

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!!!

Help

Accepted answers

@romachainani Another option with the summaries tool

All comments

@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.

Value Not Null.PNG

CT SumValues.PNG

Remove Nulls.yxmd

@romachainani Another option with the summaries tool

Quick Links

Tags

This months top contributors

Hollingsworth 335