Grouping multiple columns in a view result for a report I have a requirement in which I need to display the stock report for an application as in the below image



I want to know how to group the Quantity, Batch no and Expiry date fields together in another column (Opening Stock) in Views. I am using Drupal 7 and Views 3.

Also I need a summary of the quantity in the footer of the view, for example sum of all quantity for a batch in the footer. Any help from the community is highly appreciated...
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.