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?
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
Just what I have been looking for, great video, thanks for sharing!
Thanks a billion... I was having a similar scenario... I didn't know how to do it...
thank You so much. It was simple and straight foward.
Good job on this.
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?
What if you don't know the value for the Additional column? It varies.
did you try an index column, if you need every other row regardless of the column stop's content
Thanks!
No problem!
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
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
Why not use the "Unpivot" or "Pivot" features? I thought that's what they were meant for.
i tried them they didn't work, the way this does.
very poor video. Title is not relevant, nowadays You tube is a garbage.