Cascading Data in a Pivot Table

I am trying to create a "cascading" pivot table.  Let me explain...

If I have 2 columns of data with names of people who are in a direct reporting relationship. I want to show the data in columns as a hierarchy. So only those people who are not reporting to anyone would be in the far left column then the people who report directly to them in the next column and so on.

Column 1             Column 2

Jane                      Mark

John                      David

Sue                        Bob

Bob                        Jeff

So I want to be able to sort so that Bob would not show up in the 1st column because he reports to Sue. Bob would be in Column 2 then Jeff (who reports to Bob) would be in Column 3. Does this make sense? If not with a pivot table, is there another way to sort data this way?

Thanks for the help!