Removing Columns with immediate row below having a Null.

TwanD

Currently I use Select tool to remove unwanted columns. However, this becomes cumbersome when there are intermittent columns with first row having null and columns with actual data. Is there a tool I can use to remove all columns with first row having null in one swoop?

For instance:

F1           F2            F3          F4

Null         Data         Null        Data

I just want:

F2             F4

Data          Data

This is simplified but imagine this with many fields with that pattern and I want only columns with data. Any help is appreciated!

jrgo

@TwanD

Here's a solution for you.

I added one more row to illustrate the need for the RecordID field... without it, the Crosstab tool would concatenate fields without something to group on.

TwanD.yxmd