Transpose 2 column in one column

Question

Hi Expert,

i wanted to convert 2 columns in one row as below in excel sheet

Expected output

Answer 1

Hi @Shambhu Rai ,
You can use Power Query to get the result you need:

1. Select the Range and go to Data- From Table/Range
   
2. Open Power Query editor- Select Column b and Column c- go to Transform tab- selet Unpivot Columns:
   
3. Go to Home- select Colose & Load:
   
   

Hope it's helpful.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Any suggestions