Need a New Row at Every Instance of a Certain Character (or every X columns)

You mentioned in your first post that the data has already been transposed from a single column format. It might be easier to work with that directly, so could you post an example in that format with some representative data?

Pete