Multiple Columns data of same Employee merge in to one column

Hello Champs,

Hope you all doing good.

Need your kind assistance on the below problem statements,

Ex: i have the data in the below column format, Column1 is my unique identifier .

|Column1|:|X |Column2|:|Y |Column3|:|Z |Column4|:|A |Column5|:|B |Column6|:|C

So we have multiple employees row data in a similar way , i want to merge or combine all columns in to one column with multiple rows of same employees , i mean for employee X should have columns data in one single column with multiple line, Result should as per the below

Column1- Employee Name Column2

X Y

X Z

X A

X B

X C

Need all employees data in a same pattern. Need your kind support. Earlies response is highly appreciated.

Regards

Madhusudhan J