ok i am going to create sample data but situation changed a bit i realized transposing rows and columns are easier way to handle excel data so this whole thing will be a bit different but the goal is the same
What i want to achieve is that for each row in the excel table i want to obtain all items down to the item whose hierarchy is the same or higher level than analyzed row.
In gh output should be that for each branch (which is one row) there would be 5 subbranches corresponding to columns with indices corresponding to rows.
Yes one si private account one is firms.
I am going to have a look at your solution. It looks promising. I could think this has to be done in loop. Thank you so far
When I added code to break the Anemone data into branches, I discovered another ambiguity caused by “bad data”: two branches are combined… Looking deeper, I found an error in the white group.
This qualifies as one of those “painted myself into a corner” problems that ultimately are not fun since they could have been avoided by different actions earlier in the process (the Excel file in this case).
I will tell you why i am doing this. In excel you define your whole project structure with all contents and annexes. Using GH i plan to create title sheets. Special option is to include list of annexes belonging to each rows structure. Whole point of this data operation is to get table of contents for each row, which is bound by according to rule of subsequent higher level item than in original row.
Just to get picture behind that arbitrary data…
No no Ivan Galik is real name Juan Gallo is a joke spanish version
Data is exactly how it will come from excel. Just hierarchical structure with lot of empty cells.