How to merge one object id with same value into new array javascript [duplicate]

i have array of object transaction join with product and user table, i want to combine id with same value so it can display two different data in 1 object

Here's my data

let test = [
  {
            TransactionId: 1, //transaction table
            username: "A", //user table
            qty: 3, //product table
            product_name: "Logitech G733",
            price: $100,
            description: "Lalalalala",
            productId: 10
},
{


            TransactionId: 2,
            username: "B",
            qty: 1,
            product_name: "Razer",
            price: $200,
            description: "Blalalala",
            productId: 12
},
{
            TransactionId: 1,
            username: "A",
            qty: 1,
            product_name: "Mousepad",
            price: $50,
            description: "This is mousepad",
            productId: 7
},
{
            TransactionId: 3,
            username: "C",
            qty: 2,
            product_name: "Headphone",
            price: $300,
            description: "This is Headphone",
            productId: 2
},
]

this is the output i want

let test = [
  {
            TransactionId: 1,
            username: "A",
            qty: [3, 1],
            product_name: ["Logitech G733", "Mousepad"],
            price: [$100, $50]
            description: ["Lalalalala", "This is mousepad"],
            productId: [10, 7]
},
{


            TransactionId: 2,
            username: "B",
            qty: 1,
            product_name: "Razer",
            price: $200,
            description: "Blalalala",
            productId: 12
},
{
            TransactionId: 3,
            username: "C",
            qty: 2,
            product_name: "Headphone",
            price: $300,
            description: "This is Headphone",
            productId: 2
},
]

i tried using reduce and Object.assign but the output only shows object with "Mousepad" not make array ["logitech G733","Mousepad"]

Via Active questions tagged javascript - Stack Overflow https://ift.tt/0Cb8oBq