how to use transpose on this data please

[saadalotaibi]

how can i transform this to a vertical where first column is the name for example -> (2_OSCE_05_A) and second column is the number for example 75 

thank you

[ShankerV]

Hi @saadalotaibi 

Here is a solution for you.

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

[ShankerV]

Hi @saadalotaibi 

Tried with a multiple dataset's also, the output remains as expected.

Many thanks

Shanker V

[binuacs]

@saadalotaibi one way of doing this with the Transpose tool

[KrishnaChithrathil]

@saadalotaibi 

Adding one more way we can do this.

Input:

Output: