Hello, everyone!
I hope this finds you well

I have a large knowledgebase (+50,000 rows) of failure mode data for components that I would like to eventually turn into an interactive Fault Tree. Ideally, you would select the item branch (component) of interest, and it would expand/collapse to reveal the content below. Once the data you are interested in is presented, you can export it and customize for the specific project you are working on (include in report, for example). I believe Visio Data Visualizer is part of the solution, but feedback/advice is appreciated.

The question to the group is, How can i quickly convert the data i have (in one format) to the format that is required by the Visio Data Visualizer.

Please refer to the small sample spreadsheet attached.
Quick visio conversion.xlsx
Two sheets are included:
Sheet 1: "Sample" contains data formatted like the data in my knowledgebase.
Sheet 2: "visio convert" example of the "sample" data target formatted to work with Visio Data Visualizer

I believe VBA is the answer here, but I am not as proficient as I would like to be yet, and I am up against a timeline?

If possible, I would like to have a Excel file that helps me do the following:
1. paste data from knowledgebase into sheet1
2. run macro
3. have the macro output the data into Sheet2 in the an active visio data visualizer table.
4. Refresh the Visio data visualizer plugin.

Can you provide some advice or sample scripts to convert the data in in ?Sample? sheet to the format of the data in the ?Visio convert? sheet?

Thank you all in advance for your time and support,

Matt