Merging rows containing same value

[#1]

Hi. I have a table that has only dimensions & no Expressions.

Here are the first few rows .

Task	Sub Task
Task 1	A
Task 1	B
Task 2	C
Task 2	D
Task 2	E

I want to do a merge & center like we would do in excel in a similar situation.

Task	Sub Task
Task 1	A B
Task 2	C D E

How can this be implemented using a table box?

[Gysbert_Wassenaar]

No, that cannot be implemented using a table box. You need an expression for that and therefore a chart object like a straight table or pivot table with Task as dimension and as expression concat(distinct [Sub Task], chr(10)).

[marcus_sommer]

A tablebox could only show data how they are - you will need a table-chart and could use a calculated dimension or an expression like this:

concat(distinct [Sub Task], chr(10))

- Marcus

[#4]

This does not work.

[tresesco]

May be like attached sample.

Edit: If you are interested in values without line separator, have a look at the second chart.