Getting rid of empty cells and moving cells closer together.

[Inactive User]

I am trying to clean up some invoices and when imported to Alterytx they get kinda funky. I know I can user the cleaner tool to get rid of the Null values but than Im just left with a blank cell. 

Invoice Date	6/16/2020	Null	Null	Null
Customer ID:	Null	Null	Null	123456
Order #:	Null	567890	Null	Null
Item ID	Null	Null	Null	12221
Item Serial #	Null	Null	9876545678	Null

This is what I would it to look like. I want to be able to eliminate the empty cells and pull the other values in to the adjacent cell. 

Invoice Date	6/16/2020
Customer ID:	123456
Order #:	567890
Item ID	12221
Item Serial #	9876545678

[bpatel · Accepted solution]

hi @Inactive User ,

you can transpose the data and filter out nulls to get your end result.

hope this helps!

[Inactive User]

@bpatel 

Thanks that seems to be exactly what I need. One slight problem. On my workflow for some reason the null is greyed out so it doesn't seem to filter out he null rows like it does for your example here. 

[bpatel]

hi @Inactive User ,

In your filter try to use "isnull" that should help!