Forum Discussion

mwllms's avatar
mwllms
Frequent Visitor
7 years ago

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...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

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.

mwllms's avatar
mwllms
Frequent Visitor
7 years ago

parry2k : Unfortunately, I won't be able to share the data because it all contains sensitive company information.  If you have any links to examples or resources on what you are trying to show me that would help out as well. :smileyhappy: