Convert Excel to Json with Nested Array

[JSEH]

Hi, 

I have the below table and want to convert to json with nested array Properties as shown in the example below. 

How can I achieve this please?

Excel Data:

OwnerID	PropertyID	Property Address	Rent	Bedroom
L001	P001	12 St LA	300	2
L001	P002	3 St SA	450	3
L002	P003	4 St SA	500	4
L003	P004	20 St LA	400	2

[  
  {
        "OwnerID": "L001",
		"Properties": [
			[
				{
					"PropertyID": "P001",
					"Property Address": "12 St LA",
					"Rent": "300",
					"Bedroom ": "2 "
				}
			],
			[
				{
					"PropertyID": "P002",
					"Property Address": "3 St SA",
					"Rent": "450",
					"Bedroom ": "3 "
				}
			]
			]
	},
    {
        "OwnerID": "L002",
        "Properties": [
			[
				{
					"PropertyID": "P003",
					"Property Address": "4 St SA",
					"Rent": "500",
					"Bedroom ": "4 "
				
				}
			]
			]},
    {
        "OwnerID": "L003",
        "Properties": [
			[
				{
					"PropertyID": "P004",
					"Property Address": "20 St LA",
					"Rent": "400",
					"Bedroom ": "2 "
				}
			]}
]

Thanks

JS

[Felipe_Ribeir0]

Hi @JSEH 

One way of doing this

[grazitti_sapna]

@JSEH , Here is another way of getting your desired result.

[Felipe_Ribeir0]

Hi @JSEH 

It worked?

If yes, please accept it as a solution :)

Thanks!