Break files up into individual tabs (for ease of editting), split up manually from rawdata (color coding tab may help (red=> yellow -> green)) and edit
Concatenate (via QUERY statement in cell A2) the updated file tabs ("Dictionary (calced)" tab)
The "Dictionary (delimited)" tab will pull automatically and put pipes around each cell
Export the "Dictionary (delimited)" tab, use as input to this page (field above)
Run this page to create a file (location denoted above) to use as input to WFDICIMB (fixed length input format)
Creates a .CSV file (removing the delimeter pipes from file above) - Dictionary_work.csv
Reads the .CSV and creates a flat file for use in WCDICIMB - Dictionary_prepped.txt
