Grouping multiple columns in a view result for a report
To group the quantity, Batch no and expiry date fields in another column, use the views secondary row module


  Provides a way to split a views table row into two. In the table style
  settings, select a "Secondary row" option.
  
  So if a table looks like this: Name | Description | Edit link | Delete
  link selecting "Name" as the secondary row option for "Edit link" and
  "Description" as the secondary row option for the "Delete link" will
  render two rows:


For summary of the quantity in the footer, use Views summarize


  Enables an extra display style which displays summaries of a column on
  the last row.