Yes, I'd like the OriginID in one column separated by a comma(if there are multiple values for that particular DestID).

There may be only one value but there again, it could be up to 3. I really want one line to keep the grand total in tact but have the ability to look over in the other column, see if it had multiple OriginID's and if so which they were.

I'll see if I can get the sample data together in the morning.

Thanks!