Transposing 2 columns into dynamic rows

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?

Developer

Accepted answers

AbhilashR

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.

sample.yxmd

All comments

Aaron_Harter

Hi @vkarthik21,

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

2020-05-20 1.yxmd

carlosteixeira

Hi @vkarthik21

this other way...

Best Regards

Carlos Teixeira

Transposing 2 columns into dynamic rows.yxmd

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

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.

sample.yxmd

vkarthik21

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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703