Transform and Fill (Fantasy Football)

[cpadilla0024]

Hi,

I am trying to leverage PQ to massage some mock draft data. My original data only has Column1 I was able to extract Player, Position, and Pick. But I need to get the round that is like every 13th column. For example, it starts with Round 1. Then there are 12 picks and then Round 2. Every 13 rows, it lists the new round.

Any help would be greatly appreciated. Thanks!

 

[GraH - Guido]

Add a custom column with a conditional statement like = if Text.StartsWith( [Column1] , "round ", Comparer.IngnoreCase) then [Column1] else null.
Then fill down that column.