• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Transform and Fill (Fantasy Football)


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!

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.