hi,

I have a worksheet which has "group names" list across the tops of the columns and I am trying to produce a list of all the "Names" underneath these coulmns of the people who are members of these groups.

I have another worksheet which lists every group name and the user who is part of that group

e.g

Group Username

TYCOFS\SGadtie_DubUrs thayden
TYCOFS\SGadtie_DubUrs ngill
TYCOFS\SGadtie_DubUrs jcolfer
TYCOFS\SGadtie_DubUrs jokeogh

I need to switch this so that i have the column headings as the group name and then a list of all the user's who belong to that group

e.g


TYCOFS\SGadtie_DubUrs
thayden
ngill
jcolfer
jokeogh

help would be greatly appreciated, thanks.