Compiling data from a training report

[magpie2000k]

Hi I wonder if you can help me I have a spread sheet of training for my staff

Student

Course one

Date started

no. attempts

mark acheived

date completed

Course 2

Date started no. attempts mark acheived date completed <tbody> </tbody>

Course three Date started no. attempts mark acheived date completed <tbody> </tbody>

bob smith

first aid

01/05/2018

1

65%

02/05/2018

fire safety

<tbody>
</tbody>

The columns go on and on for multiple courses
I basically need to pull a summary for the learner

However as the columns go across the page they may or may not have taken each course

so in example above bob may have taken course on but not course 2 or three but may have taken course 4 (not shown)

What I am hoping to acheive isthe following

Delegate	Course	Attempts	Pass mark	Date achieved
Bob Smith	First aid	1	65%	02/05/2018
Bob Smith	Fire
Bob Smith	Course 3
Bob Smith	Course 4	2	75%	03/05/2018

<tbody>
</tbody>

I hope that makes some rough sense. I am more looking at the general way of doing it then I should be able to adapt the formulas.

Thanks

 

[Fluff]

As it's a new question, best if you start a new thread.

 

[magpie2000k]

Fluff you helped me with this ages ago and I have been asked to add something to it..
Thought easier to ask back on this thread as it might help you.. I get you will speak to hundreds of us...

Basically I have it pulling accross the course names. If I have a list of course names saved on say sheet (course names)
with the name they are called on teh export, can I have it update the course name in the results with new course name

Thanks in advance

 

[Fluff]

Can you please start a new thread. Thanks