Report - Merge column with row separate

[Donna_Boj]

Hello All,

Hoping someone can assist, I need to combine 5 fields into one column on a report but I need the outputs to display on separate rows.

These are the fields names:
ccoInclusionName1
ccoInclusionName2
ccoInclusionName3
ccoInclusionName4
ccoInclusionName5

I have made a start but struggling to add the other fields and I can't find the correct syntax for the separate row break.
If someone can assist me with completing this, it would be a big help.

column.17.displayname=Inclusion Name
column.17.linkedname=direct
column.17.namekey=ccoInclusionName1
column.17.querysort=DE:ccoInclusionName1
column.17.sharecol=true
column.17.textmode=true
column.17.valuefield=ccoInclusionName1
column.17.valueformat=customDataLabelsAsString
column.18.linkedname=direct
column.18.namekey=ccoInclusionName2
column.18.querysort=DE:ccoInclusionName2
column.18.textmode=true
column.18.valuefield=ccoInclusionName2
column.18.valueformat=customDataLabelsAsString

Many thanks,

[_Manish_Singh · Accepted solution]

Hello @Donna_Boj, Please refer to 'Merge columns with a link break' section in this article: View: Merge Information from Multiple Columns in One Shared Column | Adobe Workfront

[_Manish_Singh]

I think you can further enhance the readability by adding the field name and its value.
Example: 
Inclusion 1: value 1
Inclusion 2: value 2

and so on...

column.17.displayname=CCO Inclusions
column.17.sharecol=true
column.17.textmode=true
column.17.usewidths=true
column.17.value=<strong></strong>
column.17.valueformat=HTML
column.17.width=350
column.18.sharecol=true
column.18.textmode=true
column.18.value=<strong>Inclusion 1: </strong>
column.18.valueformat=HTML
column.19.linkedname=direct
column.19.namekey=ccoInclusionName1
column.19.querysort=DE:ccoInclusionName1
column.19.sharecol=true
column.19.textmode=true
column.19.valuefield=ccoInclusionName1
column.19.valueformat=customDataLabelsAsString
column.20.sharecol=true
column.20.textmode=true
column.20.value=<br><strong>Inclusion 2: </strong>
column.20.valueformat=HTML
column.21.linkedname=direct
column.21.namekey=ccoInclusionName2
column.21.querysort=DE:ccoInclusionName2
column.21.sharecol=true
column.21.textmode=true
column.21.valuefield=ccoInclusionName2
column.21.valueformat=customDataLabelsAsString
column.22.sharecol=true
column.22.textmode=true
column.22.value=<br><strong>Inclusion 3: </strong>
column.22.valueformat=HTML
column.23.linkedname=direct
column.23.namekey=ccoInclusionName3
column.23.querysort=DE:ccoInclusionName3
column.23.sharecol=true
column.23.textmode=true
column.23.valuefield=ccoInclusionName3
column.23.valueformat=customDataLabelsAsString
column.24.sharecol=true
column.24.textmode=true
column.24.value=<br><strong>Inclusion 4: </strong>
column.24.valueformat=HTML
column.25.linkedname=direct
column.25.namekey=ccoInclusionName4
column.25.querysort=DE:ccoInclusionName4
column.25.sharecol=true
column.25.textmode=true
column.25.valuefield=ccoInclusionName4
column.25.valueformat=customDataLabelsAsString
column.26.sharecol=true
column.26.textmode=true
column.26.value=<br><strong>Inclusion 5: </strong>
column.26.valueformat=HTML
column.27.linkedname=direct
column.27.namekey=ccoInclusionName5
column.27.querysort=DE:ccoInclusionName5
column.27.sharecol=true
column.27.textmode=true
column.27.valuefield=ccoInclusionName5
column.27.valueformat=customDataLabelsAsString