I have 2 CSV files. I give them out as Excel to people, but maybe CSV is easier for you to develop a script to assist me.
1. The first CSV/Excel is a registration list full detail of everyone who has registered.
2. The second CSV/Excel is a Volunteer list of people who are volunteering. (similiar data)
The goal is to take the 'job' column with each job, and somehow put each job (it is possible to have more than 1 job) with the right person onto CSV 1 (the registration list).
So in summary, We want the 'job' column merged into the first CSV/Excel, BUT keep in mind that some people have more than 1 job, and so we would need to push the next line down to fit each job onto each person.
Thought I would give this site a try.
I have attached both csv and xls just in case you prefer building a tool/script in whatever you want.
Also, this would need to be a script or a tool that I can then use going forward, everytime I run these reports.