Transpose the data to a particular column using power query.

[ajmal pottekattil yoousuf]

I am first time using the power query .

Any one please guide me to how to transpose the data .

Here we want to transpose to a particular column.

please refer my video. 

Fist video is the what is the output is required.

[#2]

Your video doesn't show what your starting point is, what does the data look like before processing? It is better if you upload an Excel file with anonymized sample data and an explanation of what you want to achieve.

[#3]

Duplicate/cont. of Transpose the value