Rename first N columns in Power Query

[@alfredo.salvadora]

Awesome. Thanks so much for this valuable tutorial. You successfully made a complicated concept into a very simple and understandble way.

[@warrenanderson412]

Very good..thank you!

[@morales723]

A fantastic solution. Thanks

[@pittwood2791]

Yes! Very enjoyed! 🤓Thanks for sharing, now magic is real!

[@norbertschmidt6532]

Thank you. GREAT.

[@elaf70]

Great & very instructive video 👏-Thanks a lot. 1 additional "improvement" could perhaps to remove null value from the 2 Lists of 2 lines of Original Headers instead of using position a specific value ("Jan")

[@MrWella1234]

Thanks for the greate tutorial, this helps me a lot 👌

[@emujkic]

Great tip. Thnx

[@alexrybalov7312]

This is nicely done.

[@Bharath_PBI]

Thank you 👍

[@performdata407]

Just Amazing

[@cosladacity1]

wowwww!!! this is good stuff!! thankss

[@kebincui]

Awesome👍👍

[@johnj108]

Brilliant..!!

[@malchicken]

🤩

[@zackcarter3634]

Thank you for the tutorial. Do you have the workbook that you can share so we can delve into your steps?

[@ExceedLearning]

Hi Zack, we added a link to download the Excel file! You can also download it here exceed.hr/wp-content/uploads/Rename-first-N-columns.xlsx

[@zackcarter3634]

@Exceed Learning thank you for taking the time to provide the associated file

[@pierreruwet8479]

Thanks for the share and the idea . Some question, the source is called multiple times in this query, does a table.buffer improve running time of the query. Also the Table.ColumnNames result is called two times, so could be store as step name bout does it change something about query running time?

[@SaniGarba]

Thank you for this helpful tutorial. Please, how would the code change if, say, the changing columns are among the Jan to Dec and not the first three. Thanks.

[@ExceedLearning]

Hi Sani, you could use the following approach. in the ColsToRename step, you need to find the anchor value of Dec, then you could insert step after and use the following code to return all column names between Jan and Dec: List.LastN(ColsToRename,List.PositionOf(Table.ColumnNames(#"Reordered Columns"), "Dec")-(List.PositionOf(Table.ColumnNames(#"Reordered Columns"), "Jan")+1)) . From there on you can build the solution using the rest of the M code.

[@SaniGarba]

Thank you very much for the detailed explanation.

[@engahmedelbendary1566]

@@ExceedLearning thx for your Effort but i hope to Explain it in video to be more easy

[@mohammadtawhidulislam4459]

Why not Using Fill Up?

[@FRANKWHITE1996]

Too clever for me 😂