Data is downloaded in a single column.
Each record ends with a number. With excel formula I can give each line of each record a grouping number.
Can not seem to replicate it in power query. IF(ISNUMBER(A2),C2+1,C2).The above M code will put a 0 in the first row and then error.
I have attached a worksheet with the query.
I could add the grouping column before starting the query but I would rather not.
Thanks for any help you can give.
Table.AddColumn(#"Added Index1", "GroupBy", each if [Index.1]= -1 then 0 else |
if {[Index.1]}[Custom]= "Text" then {[Index.1]}[GroupBy] else |
{[Index.1]}[GroupBy]+1) |