How to create a single column from some

[MinaN]

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.

[binuacs]

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

[alexnajm]

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

[MinaN]

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

Thanks so much for your support

[Royal-TV-UK-IPTV]

Sounds good

[flying008]

Hi, @MinaN 

FYI.

[binuacs]

@MinaN one way of doing this

[kanungoprashant]

+1