I have no idea how to ask this question.
I have a table that has 4 columns that I need to split and create one collection to show in a nested gallery.
I can split the 4 columns into a collection with this formula:
ClearCollect(weekCol, {Position: Split(ThisItem.Position_x0020_Training, ";"), Location: Split(ThisItem.Training_x0020_Location, ";"), 'Location Name':Split(ThisItem.Location_x0020_Name, ";"), Trainer: Split(ThisItem.Trainer, ";")})
And I get this:
Now I would like to get that (^) to where the tables are individual records instead of tables to display in a nested gallery.
| Location | Location Name | Position | Trainer |
Location Table Record 1 | Location Name Table Record 1 | Position Table Record 1 | Trainer Table Record 1 |
| Location Table Record 2 | Location Name Table Record 2 | Position Table Record 2 | Trainer Table Record 2 |
| Location Table Record 3 | Location Name Table Record 3 | Position Table Record 3 | Trainer Table Record 3 |
Might be an issue, but the 4 columns may have a different number of splits. i.e. Location may have one record, where position has 2 or 3 records.
Thoughts?
