Good Afternoon,
I'm trying to figure out how to populate a series of columns with data from a SharePoint list. Issue being, it's not always the same number of columns.
Example:
A form that's originated in Department A would need to be reviewed by John, Sally, and Sarah. Therefore, I would need a column with each of their names to appear when that department is selected. From there, each user would fill in a series of text boxes within that column during their review.
BUT if it's originated from Department B, we would need an additional two columns for Mark and Nancy to fill in.
If we just make 5 columns to start with, it looks incomplete with two blank columns.
Is there any way to perform this task??