Select Columns based on Formula?

kpmg_lc_analyst

I need to automatically select and perform operations on columns where the first record contains certain values.  For example, if you refer to the picture below, I need to automatically select the columns where the first record contains the "/".  Here, that's F2, F3, and F4. Other times, it could be different.  How would I go about doing this? 

JohnJPS

I would apply a RecordID, Transpose, apply the Formulaic Filter, then CrossTab back and Union to original table using auto-Config by Name and including only a common subset of fields.  An example of this is attached.

SelectByFormula.yxmd