Deleting null values and aligning columns

[JohnO]

I'm having an issue where I need to filter out null values and then reposition and consolidate the remaining data.

The input looks like this:

And I want the output to look like this:

Is there a way to accomplish this?

[Luke_C · Accepted solution]

Hi @JohnO 

I'd use the transpose and crosstab tools to help with this. This solution should work for any number of columns

[JohnO]

@Luke_C  Thank you! I'm not too familiar with the Tile tool, but I'll learn about it now

[Luke_C]

No problem! I'm basically using the tile tool to do a record ID for each column1 value. This helps to make the column headers in the final output consistent.