HOW TO TRANSFORM ROWS INTO COLUMNS (Power Query)

[@ibrahimnajjar7351]

Just what I have been looking for, great video, thanks for sharing!

[@ranjitjojo]

Thanks a billion... I was having a similar scenario... I didn't know how to do it...

[@StefanoVerugi]

if at 2:40 you fill up your last 2 columns, then you can filter out the column stops using High Park Loop as criteria ang get the result you need probably shorter way?

[@manmeetworld]

Good job on this.

[@Uriakus]

thank You so much. It was simple and straight foward.

[@melissagenthner2705]

What if you don't know the value for the Additional column? It varies.

[@StefanoVerugi]

did you try an index column, if you need every other row regardless of the column stop's content

[@narakdk]

it only works when the Route and Direction has the same name. How to make it work when the first coloumns has variable many names

[@bluex5115]

second custom.1 col ... - ez to test only is null or not on [custom] - and usualy all test the same - not to use entire word when u have a null to check ... gj

[@JJ_TheGreat]

Why not use the "Unpivot" or "Pivot" features? I thought that's what they were meant for.

[@ANTOINESHARPE]

i tried them they didn't work, the way this does.

[@johnwatson8203]

Thanks!

[@explainedbyvideo4405]

No problem!

[@stevecloud4soft]

very poor video. Title is not relevant, nowadays You tube is a garbage.