format json data in javascript like a Structured format and group by Category

Question

[
  {
    "Category": "Total",
    "Count": 52,
    "Status": "Q_Pending"
  },
  {
    "Category": "Total",
    "Count": 258,
    "Status": "R_Pending"
  },
  {
    "Category": "Total",
    "Count": 1,
    "Status": "RR_Pending"
  },
  {
    "Category": "Total",
    "Count": 5,
    "Status": "E_Pending"
  },
  {
    "Category": "Total",
    "Count": 26,
    "Status": "Q_Action"
  },
  {
    "Category": "Total",
    "Count": 128,
    "Status": "R_Action"
  },
  {
    "Category": "Total",
    "Count": 1,
    "Status": "RR_Action"
  },
  {
    "Category": "Total",
    "Count": 1,
    "Status": "E_Action"
  },
  {
    "Category": "E",
    "Count": 5,
    "Status": "E_Pending"
  },
  {
    "Category": "E",
    "Count": 1,
    "Status": "E_Action"
  },
  {
    "Category": "Q",
    "Count": 26,
    "Status": "Q_Action"
  },
  {
    "Category": "Q",
    "Count": 52,
    "Status": "Q_Pending"
  },
  {
    "Category": "RR",
    "Count": 1,
    "Status": "RR_Pending"
  },
  {
    "Category": "RR",
    "Count": 1,
    "Status": "RR_Action"
  },
  {
    "Category": "R",
    "Count": 258,
    "Status": "R_Pending"
  },
  {
    "Category": "R",
    "Count": 128,
    "Status": "R_Action"
  }
]

I want to format it so that the Category are all grouped under each category like this:

[
  {
    "Category": "Total",
    "Q_Pending": 52,
    "R_Pending": 258,
    "RR_Pending": 1,
    "E_Pending": 5,
    "Q_Action": 26,
    "R_Action": 128,
    "RR_Action": 1,
    "E_Action": 1
  },
  {
    "Category": "E",
    "E_Pending": 5,
    "E_Action": 1
  },
  {
    "Category": "Q",
    "Q_Action": 26,
    "Q_Pending": 52
  },
  {
    "Category": "RR",
    "RR_Pending": 1,
    "RR_Action": 1
  },
  {
    "Category": "R",
    "R_Pending": 258,
    "R_Action": 128
  }
]