Display vertial comparison from table (Have image)

[Korn_Tris]

hello I want to create a table C to display vertical compasison from Table A , which select in table B

Can i use like sequence and currentvalue formula to display this?

I currently use Withname and mannualy put number on, but I would like to know if I could use Sequence and currentvalue to help my formula

I tried to apply formula from transpose table

Transpose table - #6 by Paul_Danyliuk in this link from @Paul_Danyliuk

but it didn’t work as i expected

[Korn_Tris]

I applied transpose table to my table and it finally works. can close this post

[Pch]

Glad to know you were able to solve your issue !

[Paul_Danyliuk]

Awesome!

There’s an even more advanced side-to-side mechanism used in the Duplicate merger template but I’m asking a premium for it.