The pivot table wouldn't have worked with this. I have actually over 700
rows of data where many of the systemlist have combined systems. To go thru
and manually break them out would have taken days. But thank you so much for
the help!!