Help with a VC

I have a Projects Table

I Have a Time Table referencing the Projects Table
I have a Time Notes Table Referencing the time Table

In the Projects Table i have a virtual column called Related Time Notes with the formula
select(Time Notes[Time Notes],
[T_ID].[Project]=[_THISROW].[PO Ref])

currently, it looks like this in the view

Simon Bluck left the following note I am Groot on 01/19/2024 , Simon Bluck left the following note Im Batman on 01/19/2024, Simon Bluck left the following note I'm standing out on 01/19/2024

is there a way to get it to look like

Simon Bluck left the following note I am groot on 01/19/2024 ,
Simon Bluck left the following note Im Batman on 01/19/2024 ,
Simon Bluck left the following note Im standing out on 01/19/2024

0 1 64
1 REPLY 1

 

I think you could avoid the manually created VC expression by using an expression based on system generated VCs.

You may have a system generated VC called something like [Related Times] in the Projects table.

You may have a system generated VC called something like related [Related Time Notes] in the Time Table.

If so then you could have an expression for the column [Related Time Notes] in the Projects table something like SPLIT(TEXT([Related Times][Related Time Notes]))

Now to have those list values with line breaks, you could modify the expression something like '

SUBSTITUTE(SPLIT(TEXT([Related Times][Related Time Notes])), ",", " ")