Transposing 2 columns into dynamic rows

[vkarthik21]

Edited the original question
---
I have two columns in a table - 



I am trying to convert it into the following table -

I have been trying to use transpose, cross tab and multiple methods but I am not able to get the desired result. Any suggestions?

[Aaron_Harter]

Hi @vkarthik21,

This is a great use case for the concatenate function in the Summarize tool:

[carlosteixeira]

Hi @vkarthik21 

this other way...

Best Regards

Carlos Teixeira

[vkarthik21]

Thanks Alan and Carlos for your reply. I have now edited my original question. Sorry for the confusion. I don't have a concatenated data. I have a file with two columns which I want to transform to rows.

[AbhilashR · Accepted solution]

Hi @vkarthik21, does the approach in the attached workflow address your ask?

If this resolves your query, I request you to accept one of the other two solution submissions that came most close to your original ask.

[vkarthik21]

Thanks @AbhilashR .I am seeing the true power of tile and recordnum. This is fantastic solution.