Hello everyone, I'm currently having issues with getting different values from one table to one row in different columns.

i currently have 3 columns that each pull different values from the same table. but they appear as 3 rows with only the section filled out, instead of one row with each columns section filled out.

i created 3 formulas one in each columns.

if {sc_Observation.FindingAbbr} = 'W_DMTeachMethod'
then {sc_Observation.Value}

if {sc_Observation.FindingAbbr} = 'W_DMTeachMethod'
then {sc_Observation.Value}

if {sc_Observation.FindingAbbr} = 'W_DMEvalMethod'


and this under select expert record
{sc_Assessment.FormUsageDisplayName} = "Education - Specific" and
{sc_Observation.FindingAbbr} in ["W_DiabetesSelfMa", "W_DMEvalMethod", "W_DMTeachMethod"]
then {sc_Observation.Value}

tried that but wasn't very successful. this is what I currently looks like
Name      Start     Stop   diabself teaching   evalmeth
john doe 1/8       1/9    Health
john doe 1/8       1/9              discussion
john doe 1/8       1/9                          verbal

I would like it as this
john doe 1/8       1/9    Health    discussion   verbal

thank you I will try your suggestions again , the ex I had shown before was just how it looked before any additional config and what I wanted for it to look like. Its been a while since I used crystal so some things are slow to come back to me.