Forum Discussion
ooptennoort
Advocate I
Advocate IExtract same range multiple times out of 1 table into multiple (sub)tables
I need to split a table into a range everytime Table.PositionOf finds the "Marker word". It works when using only 1 Occurence (.First or .Last) but .All produces more than 1 number in the list and Ta...
Hello, ooptennoort try this:
positions = List.Buffer(Table.PositionOf(Source,[Column1="Marker word"],Occurrence.All,"Column1")), ranges = Table.Combine( List.Transform(positions, each Table.Range(Source, _, 5)) )
ooptennoortAdvocate I
Advocate IWow, such simplicity and without any recursive functions! Amazing. Thank you so much!!!