Split() Function or something like it

[boblarson]

Thanks Bob! Hopefully this is an interesting problem for you to work out.

Can you give a better explanation of what you are looking for within the context of the Excel file you attached and the structure I had suggested? Do you need all fields repeated for each record, what?