I have a table where the columns are different shifts and the rows are
names of people that are available to work that particular shift.

eg:

1/1 7-3 2/3 3-11 3/15 3-11
Joe Joe
Mary Mary
Dave Dave



I'd like to be able to reformat this table so that it's organized by
person rather than shift, so I'd have


Joe Mary
1/1 7-3 1/1 7-3
2/3 3-11 3/15 3-11


I've been playing around with the PivotTable Wizard but it doesn't seem
like it will do what I want--is this possible with a PivotTable? If not,
is ther another way to do this?

thanks--