I am trying to create a report which contains the following:
Parent main email address
Quite simple I think. However, I am getting the following:
* Admission Number
* Blank Email
* New Row
* Blank Admission Number
But not consistently. Sometimes, the admission number is on the same row as an email address, somtimes not. Sometimes, the same email address is repeated on multiple rows etc...
Any ideas how I can get Admission numbers and Email addresses on the same rows?
I need it in a simple format, as I intend to import it programmatically into our cashless catering system. I'd prefer not to have to figure out some form of weird parsing mechanism to get it to stick things together properly...