Forum Discussion
Needed Help!!! Data cleaning/transforming
Aren't you only needing lines where the first column has D? Then get all the lines the filter (in Powerquery) the lines with D in that column. Then remove the not needed columns.
Hi, I also need date listed in H, and the number next to it.
I would also need "I" row elements to appear in a column
ah ok, that's a different story :-)
As with another similar request a few days ago, it's fairly complex as you can't reference "other rows" in PowerQuery. So you can't really tell "go to the NEXT line and get a value". Generally speaking, you can't guarantee a sequential order. Granted, you can create a key column and put a number, but, even in DAX, how can you tell which row where to look for the three values to put in column?
IF you could have a way to put the same value on all of the rows of the same "group" (the D ones and the corresponding I) it could be done via DAX...