The Friday Excel Conundrum!

[Montse]

Hi all

 

Its been a while since i did some data manipulation and after a long week my brain is mush so thought I'd ask the venerable forumites

 

I've been given a list of employees training records including name, email, manager and the training they have completed and when. The training course name contains multiple types of course so the list itself will duplicate the delegates details depending on how many courses they have completed - there are about 6 different courses in total

 

What i would like to do is consolidate this so I have one line for the employees data then in subsequent columns filter out the courses so the course completion date appears in a separate column under the heading of the respective course - ie so i can see who has done what and when

 

I'm using MS Excel 10 which I am fairly new to as well - can someone (in simple terms) give me a clue on how to do this please

 

As always, I'd be eternally grateful

[StevieC]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Montse]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[PhilM]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[charlie clown]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[SkippyjonJones]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here