Data to Data – Summary to Summary

Spread the love

Data to Data –

  • select data
  • insert a pivot table

ExcelinHindi.com - 1Data to Data

  • Pivot table is showing summary in compact form
  • Now do some changes through design
  • Set subtotal and Grand total off
  • Select layout in tabular form and select repeat all item labels option

 

ExcelinHindi.com - 2Data to Data

 

  •  Data has been grouped and total rows are 41259

ExcelinHindi.com - 3Data to Data

 

Grouped/Summary data to Summary

  • First insert a pivot table
  • Refer table/range to pivot table ( select source must be in raw data form)
    • You can also put a dynamic range for it – for auto refresh – (specially when you use “Report Filter”)
  • Now you can create a Summary

 

ExcelinHindi.com - 1Pivot Summary to Pivot Summary

  • Now you can create a summary from Pivot table or you can do some manipulation on it

ExcelinHindi.com - 2Pivot Summary to Pivot Summary