Dynamically column name change in power query from Excel

[Anil2264]

Hi Team,

I am having column names which are having 1000 length and more but i want a dynamic column name as per my requirement using abbreviation for that column. Kindly suggest how we can achieve it.

@amitchandak  Please help

Thanks in advance

[Anonymous]

@Anil2264 

If you just want to create abbreviations for multiple column names You can use Table.Renamecolumns.

Table.RenameColumns - PowerQuery M | Microsoft Docs

[jennratten]

Are you wanting to map the current column names to corresponding abbreviate versions or just limit the number of characters in the column names?

[Anil2264]

I want to squeeze my column size in report & if it is squeezing size then it has to be renamed as per required name