I need to create an Excel table with all functional locations, but what I got is a list of F/L in different columns according to their hierarchy. I need all of them under the same column.
It may sound strange, but if you look at the attached picture you will find the right picture have F/L which are not part of the F/L on the left picture. I understand the way the structure was created is the cause of having more F/L than the one I originally picked in the left picture.
I noticed that when I input a list of f/l starting with the parent f/l, and ending with the last subordinate f/l in the selected range, then I got f/l that does not within the range, they somehow are inserted into the column. Any explanation why this happen?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.