Creating a consolidated list based on multiple values

I have a worksheet that I use for some internal reconciliations and I'm trying to figure out a way to create a consolidated list of discrepancies and amounts from this worksheet. Attached is a snippet from the worksheet showing a couple of the categories that I check for discrepancies in.  I have 19 of these categories and what I'd like to be able to do is have a list that only pulls the line items that have a non-zero value in either of the Discrepancy columns.  The list would need to populate values for the discrepancy amount, the category type (AACC2 and ACRT2 in this example), as well as a few other columns from the sheet like Name, Employee ID, etc.  I know enough in Excel to be dangerous, but I don't consider myself an expert in any way.  Is this possible?