Forum Discussion
Dynamically create a new table with multiple concatenated columns
I have a SharePoint list with 60+ comment fields. I want to create a new table with a calculated column for each comment with the following format: Current Date + Submitter + Comment Since there...
Hi parry2k : Thank you for your help. I am not sure what you mean by unpivot the data. What I am trying to do is combine three columns into one and I am trying to do this process for 60+ columns. For example:
This is an example of what the table looks like. I want to combine:
Date Submitted +Submitter + QuestionNumberComments for each of the 60+ columns in the most efficent way possible.
The end result would look like this:
Do you know of a better way to accomplish this than to create a column on by one?
mwllms yes unpivot will make it easier, if possible Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.