Hi,
I’m trying to duplicate some information in excel. basically, I have some structured data :
{
“email”: “email@email.com”,
“id”: “1”,
“orders”: [
{
“orderId”: 2,
“date”: “01-01-0001”
},
{
“orderId”: 3,
“date”: “02-01-0001”
}
]
}
in this case I would like to duplicate the “email” and the “id” for each order
mean:
&=data.email | &=data.id | &=data.order.orderid | &=data.order.date
there is any way that I can achieve that without changing my data structure?