Collapse matrix results

[Nevi1211]

Hello,

I'm trying to get from the table below with different results on each row into a single row.

Name	Test 1	Test 2	Test 3	Test 4	Test 5	Test 6	Test 7	Test 8	Test 9	Test 10
Tom	N/A	ok
Tom	N/A		ok
Tom	N/A								fail
Tom	N/A					ok
Tom	N/A				ok
Tom	N/A			fail
Tom	N/A						ok
Tom	N/A							ok
Tom	N/A									ok

into 

Name	Test 1	Test 2	Test 3	Test 4	Test 5	Test 6	Test 7	Test 8	Test 9	Test 10
Tom	N/A	ok	ok	fail	ok	ok	ok	ok	fail	ok

I tried multi row formula / summary without success so far.

Many thanks,

Nev

[Qiu]

@Nevi1211 
Hope this will work for you.

[ShankerV]

Hi @Nevi1211 

I was able to reach the solution with the help of same Summarize tool and Multi Field Formula tool.

Hope you tried Multi Field Row tool, I instead used Multi Field Formula tool.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[binuacs · Accepted solution]

@Nevi1211 Another approach to maintain the order of the column sequence

[Nevi1211]

Thank you all, all these are good solutions !