How to separate values based on category?

See more:

VBA

<bParameters                       Path

DCI_SIMPLE_APP_CONTROL_WORD        Category 1/Sample App
DCI_SIMPLE_APP_STATUS_WORD         Category 1/Sample App 
DCI_BLE_TEST_SETTING_1             Category 1
DCI_BLE_TEST_SETTING_A             Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_B             Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_C             Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_D             Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_E             Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_F             Category 1/Group 1/Category A
DCI_BLE_TEST_SETTING_2             Category 1
DCI_BLE_TEST_SETTING_3             Category 1
DCI_BLE_TEST_READING_1             Category 2 
DCI_BLE_TEST_SETTING_4             Category 2 
DCI_BLE_TEST_READING_2             Category 2 
DCI_BLE_TEST_READING_3             Category 2 
DCI_BLE_TEST_SETTING_5             Category 2 
DCI_BLE_TEST_SETTING_6             Category 2 
DCI_BLE_TEST_SETTING_7             Category 2

Parameter and path are 2 columns in sheet.
Here i have parameters to be printed based on the path. The path has to look like below.
The parameters should be categorized in to categories. I need VBA script to print the same path below in generated file.

"Category 1": {
"Setting 1": {

}
"Group 1": {
"Category A": {
"Setting A": { 

}
"Setting B": { 

}
"Setting C": {

}
"Setting D": {

}
"Setting E": {

}
"Setting F": {

}
}
} 
"Setting 2": {

}
"Setting 3": {

}
"Sample App": {

}
"Category 2": {	

"Reading 1": {

}
"Setting 4": {

}
"Setting 5": {

}
"Setting 6": {

}
"Setting 7": {

}
"Reading 2": {

}
"Reading 3": {

}
}

What I have tried:

I posted the same question in Excel forum and mr.excel.com. Below are the links attached. But still i didn't get any response regarding to my query. Please let me know the solution to the issue.

[^]

How to separate values by path??[^]