Remove Text from Headers - PowerQuery

[lofgren]

Hello all,

I have a big table (around 4000 columns) with a header that looks like this:

Date l Req - Apple l Del - Apple l Hours - Apple l Time - Apple l Req - Carrot l Del - Carrot l Hours - Carrot l Time - Carrot l Req - Carrot l Del - Orange l Hours - Orange l Time - Orange

I am using power query to import ALL "Req" columns in one REQ sheet, ALL "Del" columns in another DEL sheet, ALL "Hours" columns in another HOURS sheet and ALL "Time" Columns in another TIME sheet

So in the end i will have 4 sheets (REQ, DEL, HOURS, TIME) that should have the following header:
Date l REQ - Apple l REQ - Carrot l REQ - Orange ...etc

Is there any chance i could use a formula in power query in order to remove "REQ - " from header, when loading the data to table, in order to look like this:

Date l Apple l Carrot l Orange

Thank you

[alansidman]

In PQ Editor
Use Headers As First Row
Highlihgt your Columns
Replace Req with nothing
Use First Row as Headers

Found on the Transform Tab

[lofgren]

Thank you so much Alan
It was so simple...
The only thing i did beside what you said was to convert all the columns from whole number to text, replace the REQ, use first row as hearders and then convert again text to values.

Best regards

[alansidman]

Glad to hear it worked for you and thanks for the Rep