Remove all columns after certain value

[davidz106]

I want to remove all columns after the column that is named "Q3". How should I write this in M?

The number of columns before Q3 is dynamic. 

Regrads,

Dave

[Vijay_A_Verma · Accepted solution]

Insert following statement where you can replace Source with previous step

= Table.RemoveColumns(Source,List.RemoveRange(Table.ColumnNames(Source),0,List.PositionOf(Table.ColumnNames(Source),"Q3")+1))

[davidz106]

Works lika a charm! Thank you!