Hi,
Using pivot table on the second sheet, you can easily achieve your required
data. Put "Role" in the row lables, "Training" in the column labels and drop
"training" in the middle again.

Thanks,
Aamer

mozzie wrote:
The raw data stands as :

Required Training
Training 1
Training 2
.....

and the other list is as follows
Role 1 Training1
Role1 Training2 etc.

as you showed below that is exactly how I wish my ouput to be.
Is there a way I can achieve this?

Hi,
Can you please explain the raw data sheets' format. I believe you want the
[quoted text clipped - 13 lines]
role. Is there any easy way to do this? I've tried a pivot table but it
doesn't seem to work?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200901/1