How to to a join but only to one line

[NY2BOS]

Hello everyone one input looks like this 

Value	Item
$100	TShirt
$200	Pants

The main flow looks like this

Group	Item
1	TShirt
1	TShirt
1	TShirt	$300
1	Pants
1	Pants

Im trying to have the data look like this 

Group	Item	Value
1	TShirt	$100
1	TShirt
1	TShirt
1	Pants	$200
1	Pants

Without getting to complicated I know the blanks are not recommended but how the report needs to be viewed I dont want the value to be in every value just the first one. 
Thank you

[aatalai · Accepted solution]

I would use a join and then that would get something like what you are trying to get but with values in every value cell.

Then use a multi row formula

with if [item:row] != [item:row-1] then [Value] else empty() endif

@NY2BOS let me know if that helps

[NY2BOS]

Thank you that logic seems to work, just one more quick question can i sort? the logic works but the items arent sorted

[aatalai]

@NY2BOS yh use the sort tool on item or group and set to ascending let me know if that helps