Pivot Data from rows to columns with many possible values for pivot field

@rsramkoski thanks for that.

but when I try that, I get it as below

and at the end I still get it as

my end structure should come as below

[
  {
    "order-lines": [
      {
        "line-num": "00010",
        "attachments": {
          "type": "AttachmentText",
          "intent": "Supplier",
          "text": "2021-07-29 20:08 :-  Line 10 change Item text"
        }
      },
      {
        "line-num": "00020",
        "attachments": {
          "type": "AttachmentText",
          "intent": "Supplier",
          "text": "2021-07-29 20:08 :-  Line 20 change Item text"
        }
      },
      {
        "line-num": "00030",
        "attachments": {
          "type": "AttachmentText",
          "intent": "Supplier",
          "text": "2021-07-29 20:08 :-  Line 30 change Item text"
        }
      }
    ]
  }
]

hope that helps.

Thanks
Manohar