Need to divide multiple columns by 100 in Transform

[Anonymous]

Good Morning,

I have a spreadsheet that has many columns I need to divide by 100 after import so percents displays correctly.  Is there a way to do this in mass?

I wont let me use the Standard > Divide function when selecting multiple columns

I assume I can achieve this in Advanded Editor?

[Anonymous · Accepted solution]

@Anonymous 

Add the following step in your advance editor. 

 #"/100"  = Table.TransformColumns(NameOfPreviousStep, List.Transform({"Column1", "Column2", "Column3"}, each {_, (inner) => inner / 100, type number}))   

See the following example divides the 3 columns by 100. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[BrianCSCKOF]

This is what I was looking for. Thank you.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format?

[Anonymous]

I am getting a post flooding error- I will try again a few