Hi

I receive a simple list of employees, against each the immediate superior is mentioned. It looks like this
Col A / Col B
Emp / Reports to
B A
C A
D A
E F
F G
G A
H I

Out of this 2 column table, i want to add each Report to new columns example:
Col A / Col B / Col C / Col D
Emp / Report to / Emp / Emp / Emp / Emp /
B A B C D G
and so on...

Please help, I'm not the best at writing macros....!