I am in need of a Macro for Excel that will take the datafile (each record is either one or two lines depending on the type of record) attached and parse it into columns and rows (one row per record). The record format varies by record type. There are three types of records: N, S and L that I am interested in. The first 6 fields are identical in each record then there is different criteria based on the record type.
