If I'm understanding this correctly, your Excel data has one or more rows for each transaction and price type, then one row with the summary charge in that transaction. Something like...
*Standard
*Senior
TOTAL
*Standard
TOTAL
*Standard
*Under 16
*Senior
TOTAL
Sound correct? If so, I would write some DATA step code to read this file. Do a Save As from Excel as a CSV or Tab-delimited file and then read in the result with a DATA step. The name for these types of raw data files is hierarchical, and there's an example of code to read one of them here...
http://support.sas.com/kb/24/654.html
There's also alternative code from Warren Repole here...
http://www.repole.com/dinosaur/hierarchical.html
I can't think of a way to use the importing choices in Enterprise Guide to read this in since it involves mixed record types. You could fool around with the Excel file up front as an alternative, but unless you're an Excel grandmaster that would probably be more trouble than writing the DATA step code. Hope this helps!