Hi all,
I'm required to format .txts into a series of reports.
After removing some columns and filtering the courses, this is an example of what I have left (Cols. A to G), with each person having 4 rows of data. The number of people on the report varies. I don't know how to do the final bit.
What I require is;
(As per bottom of the image)
Written to Sheet2
A Header inserted (EID - Name - Branch - Course 1 - Course 2 - Course 3 - Course 4)
Each person to have one row of data with the expiry dates of the courses (Col G) moved to under the correct course.
I hope someone is able to assist me.
Thank you.
I'm required to format .txts into a series of reports.
After removing some columns and filtering the courses, this is an example of what I have left (Cols. A to G), with each person having 4 rows of data. The number of people on the report varies. I don't know how to do the final bit.
What I require is;
(As per bottom of the image)
Written to Sheet2
A Header inserted (EID - Name - Branch - Course 1 - Course 2 - Course 3 - Course 4)
Each person to have one row of data with the expiry dates of the courses (Col G) moved to under the correct course.
I hope someone is able to assist me.
Thank you.