Hello, I'm trying to get from the table below with different results on each row into a single row. NameTest 1Test 2Test 3Test 4Test 5Test 6Test 7Test 8Test 9Test 10TomN/Aok TomN/A ok TomN/A fail TomN/A ok TomN/A ok TomN/A fail TomN/A ok TomN/A ok TomN/A ok into NameTest 1Test 2Test 3Test 4Test 5Test 6Test 7Test 8Test 9Test 10TomN/Aokokfailokokokokfailok I tried multi row formula / summary without success so far. Many thanks, Nev

Collapse matrix results

Hello,

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

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

Datasets

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

@Nevi1211
Hope this will work for you.

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

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

Thank you all, all these are good solutions !