/RANT ON Once more let us clarify exactly what JCL is.
it is Job Control Language.
By itself it does nothing. It is used to invoke the chosen program and to define which datasets are to be used by the DD names associated with the chosen program.
JCL does not have magical powers that solve all problems, JCL is merely the vehicule for telling the processor which program you want it to execute. /RANT OFF
So, if you might just care to tell us which program you wish the JCL to execute, we might be able to help you
Also, "column" is mainly used in the context of DB2 Data Bases - files contains records, not rows or columns.
Suggest, you show exaple of input and expected output with the rules to get the output. And tell us, what utility/program you wish for to achieve your results as expat has asked for.