I have a CSV file with data that is structured like this:
After converting the CSV to JSON, the output looks something like this:
{
"Item1": "Data1",
"Item2": "Data2",
"Number1": 2209,
"": 2210,
... and so on
}
However, I would like the JSON format to be rearranged as follows:
{
"Item1": "Data1",
"Item2": "Data2",
"Number1": {
2209,
2210,
2210,
... and so on
}
}
Is it necessary for me to write a script in order to achieve this format? Appreciate any help. Thank you.