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: (...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    Varan_15 

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

     

    2. merge column

     

    3. select merge column and pivot column

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

you are welcome

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

ryan_mayu ,

 

there is second scenario if i want to keep all the input rows as named like input 1 and input 2..... how can we achive this way for example

 

Thanks,