Forum Discussion

Varan_15's avatar
Varan_15
Icon for Helper III rankHelper III
3 years ago
Solved

convert Row to column in powerquery

Hi all,

I have source data which is contain row level process step i need to split into column level data in edit query transformation.

ex: source file

 

Expected result using edit query: (Process row steps (input,review,print)  need to convert into column level with IN and OUT time)

 

 

Thanks,

Varan

  • Varan_15 

    1. SELECT IN TIME and OUT TIME , then unpivot columns

     

    2. merge column

     

    3. select merge column and pivot column

5 Replies