Big Country Posted September 29, 2008 Share Posted September 29, 2008 So... I have an interesting dilemma. I have an org structure that is 13 levels deep. The problem is, all I have is a listing of the structure so that I have an id number, the organization, the level in the structure, the parent org id and the child org id (this just lists the first child from the list). Basically I am trying to figure out a way to convert this list into a table that shows the org structure. Any thoughts other than manually cut and pasting, etc.? Quote Link to comment Share on other sites More sharing options...
gbpfan1231 Posted September 29, 2008 Share Posted September 29, 2008 Off the top of my head without seeing the original I am not sure I understand? My first thoughts are to create some sort of unique field by using concatenate() and then do Vlookups or hlookups off of that unique field to get the info you want. You could PM the spreadsheet or let me know if you want my e-mail address and maybe I could help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.