I am trying to combine 2 lists:
first list (A-D) has no sublists
second list has sublists, and first level relates to the first list.
To my mind, it is a child-parent relationship- I need the parent (first list) to be repeated for each child, i.e as shown in the Excel spreadsheet.
A1, A2, B3,C3,C4,C5 etc
The closest I have been able to get it is this:
thanks in advance