Automatically Convert To Treeview

[Draperies]

I have different table headings that I would like to automatically convert into a treeview. Some examples of this are the following:

My goal is to automatically produce a treeview that would look like the following for the first example:

-Total
-Student Type
-High School
-College
-Shown Stimuli
-Saw
-Did Not See

And this for the second:
-Total
-High School Students
-Pre Stimuli
-Group 1
-Group 2
-Group 3
-Post Stimuli
-Group 1
-Group 2
-Group 3
-College Students
...etc

I have been working on this for sometime and have gotten basically nowhere on it. Part of the problem is that the merged cells seem to only store the value for all the merged cells (and unfortunately I have no choice but to keep them as merged cells) in the upper leftmost cell... although even if that wasn't a problem I still am having tremendous difficulty getting anything to work with this. ANY direction or help on this would be greatly appreciated. Thank you!

 

[Draperies]

Yes, I actually did consider that. Copying what was there to some temporary location and unmerging everything to work with. The only problem is I then cannot tell which items belong under which parent since the merge was representative of that. So for example, "College" now appears to be on it's own instead of under the parent "Student Type".

By the way, thank you for taking a look at this so far. I know this is an extremely annoying thing to work with.

 

[Norie]

I thought it was still clear, or even clearer, going by the underlining perhaps what the nodes/date.

Maybe I've been looking at it too long.

If I had this sort of data I'd probably try restructuring the data manually (obviously using copy/paste etc).

Hopefully after doing that a few times something would emerge that could make things simpler, and perhaps eventually coded.

I'll have another look later.

Anyway, I think I may have neglected an important part of the whole thing - the actual treeview.

 

[Krishnakumar]

Hi

This might be a useful one.

 

[Draperies]

I think you're right Norie, it is clearer going by the underlining with the unmerged cells. I'll try and combine your recommendations and some of the example of your file Krishnakumar. I'll post something if I come up with something!

Thanks guys.