Column in Table block to display combined values of multiple columns or other Collection

Hi all,

Thanks for any help in advance.

Is there any way I can add Table block column just for displaying purpose having combination of multiple fields’ values, or even from other Collection’s field values?
e.g.
Fields in CollectionA: col01, col02, col03
Expected columns in Table block:
Column1: col01 Column2: col02 + ’ ’ + col3

Fields in CollectionA: col01, colX
Fields in CollectionB: colX, col02, col03
Expected columns in Table block:
Column1: CollectionA.col01 Column2: CollectionB.col02 + ’ ’ + CollectionB.col03

Thanks!

Regards,
Simon.

Redundant fields need to be created to store these values for shared display.