convert Row to column in powerquery

[Varan_15]

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

[MSuser5]

Hi All,

can we achive this using summarize calculated column ?

[ryan_mayu · Accepted solution]

@Varan_15 

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

2. merge column

3. select merge column and pivot column

[Varan_15]

@ryan_mayu ,

Great job thanks it's working fine.

[ryan_mayu]

you are welcome

[Varan_15]

@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,