Condense Data

[jomili]

I'm running expense data, and there's a lot of detail to it. Every day I open 27 expense detail files, and in each one there's a pivot from which I pull my data. I copy all of this data, and run through various exercises to boil it down. I'm trying to make the data more palateable to the managment team, and so want to condense/remove unwanted lines. The attached document has a small sample of the data I'm looking at. I've provided 2 views: original format, which is how I originally see the data (the Pivot details), and Consolidated, the data once I've done all of my whitling down.

The part I want to condense has to do with the Requistions, which show in the Consolidated sheet Label column as an A or Z followed by 9 digits, or on the Original sheet in the REQ_ID column (column AL). What I'd like to do is combine all of the line item Descriptions for one Req into the same cell, keep that line and delete the others. But I don't know how to begin doing it, nor whether it would be better to do it in the Original, or in the Consolidated.

I'd appreciate any help I can get on getting this one started.

Thanks,
John