How to arrive unique values as per account

[Lalaiah]

Hi Team,

I have the input as below and need output as per below mentioned. Can you please how to arrive this.

Input
Account	Department	PO
1	56	1
2	23	2
3	56	3
1	23	4
2	45	5
3	53	6
4	75	7
5	96	8
6	85	9
1	63	10
2	79	11

OutPut
Account	Department	PO
1	56/23/63	1/4/2010
2	23/45/79	2/5/2011
3	56/53	6-Mar
4	75	7
5	96	8
6	85	9

[ShankerV]

Hi @Lalaiah 

This can be achieved in 3 steps.

1. Sort tool

2. Select tool

3. Multi row formula tool

Many thanks

Shanker V

[ShankerV]

Hi @Lalaiah 

Step 1: Sort tool

Account -> Ascending

PO -> Ascending

Step 2: Select tool

To modify the data type as V_WString for the columns [Department and PO]

Step 3: Multi-Row Formula

IF [Account] = [Row-1:Account]
THEN tostring([Row-1:Department]) + "/" + tostring([Department])
ELSE [Department]
ENDIF

Many thanks

Shanker V

[Qiu · Accepted solution]

@Lalaiah 
We can use the Summarize Tool

[Lalaiah]

@Qiu  & @ShankerV  Thank you so much this logic working fine.