I have a hierarchy of office data that is set up on one column (A) and need to get this into a flat file format table with multiple columns. Below is a view of what column A Looks like:
Untitled.png
Need to convert above list into table with multiple columns with column 1 being the parent, and columns to the right being the children....
So to the right of Column A I will have a separate table with 8 columns. With parents/grandparents on the far left (Column B) and all the individual children to the right.
Let me know if you have any questions.
Thanks!
Bookmarks