How to create a single column from some

Hello

I need help on creating a single column based on other column
I have table which has below column

Code, level1, level2, level3, level4, level5, level6
So I need to create a Description column like below format
code Description
123 Level1's value
123 level2's value
123 level3's value
123 level4's value
123 level5's value

Kindly suggest!

Thanks in advanced.

Workflow

Developer

Transformation

Help

Accepted answers

All comments

@MinaN can you provide a sample input file and expected result for better understanding?

Sounds like a Transpose tool, but agreed with @binu_acs that more info would be better

Hi @binu_acs & @alexnajm , I have attached a sample file with sample input & output.

Thanks so much for your support

Royal-TV-UK-IPTV

Sounds good

FYI.

录制_2025_04_22_08_33_40_294.gif

@MinaN one way of doing this

sample (12).yxmd

kanungoprashant

+1

Quick Links

Tags

This months top contributors

erich_shiino 280