I have converted a recordset into a string of text where each field is separated by a ',' and each record separated by a '|'
The format of the data string is similar to:
name, date, duty| Jim, Mon, Office | Jim, Tue, Office | Jim, Wed, Holiday | Jim, Thu, Meeting | Jim, Fri, Meeting | Sue, Mon, Office | Sue, Tue, Meeting | Sue, Wed, Holiday | Sue, Thu, Holiday | Sue, Fri, Holiday | etc.
The array is therefore something like:
My question is...
How can I rearrange this data in a HTML table so it looks something like the example below?
name, Mon, Tue, Wed, Thu, Fri
Jim, Office, Office, Holiday, Meeting, Meeting
Sue, Office, Meeting, Holiday, Holiday, Holiday