Data Investigation

[bh1789]

Any help would be appreciated.  I am trying to remove nulls from columns without removing any rows.

Thank you

[atcodedog05]

Hi @bh1789 

Easiest way would be split it, filter and join back on position like below.

Hope this helps :)

[atcodedog05]

Hi @bh1789 

Here is dynamic approach.

Hope this helps : )

[Raj]

@bh1789 
one way of doing this.find the dynamic way 
hope this helps

mark done if solved.

[CoG]

Here is an alternative, more complex, but more dynamic solution that utilizes the Transpose and Cross Tab Tools to enable adjustment of all columns. MVT (Most Valuable Tool) is the Formula Tool that adjusts the RecordID field, which is what removes all initial nulls in each column:

Hope this helps and Happy Solving!