I have an excel with the data in the below format
Rows at level 1 is a parent to the next subsequent rows at Level 2.
For ex: Development (row 2) is parent to Java, dotnet, php (rows 3,4,5)
Testing (Row 6)i s parent to Manual, Automation, Load (rows 7, 8, 9)
How can I merge/join each parent (Level 1) to its childs (Level 2)?
Desired output after joining:
Excel attached for referencehierarchy.xlsx (10.8 KB)