I want to divide a single number between multiple cells

[kingfisher225]

Hello, I want to take a singular number say 300,000 and divide it between multiple cells. I am looking to make each cells value 1400. Theoretically this would break it down for me and then leave one at the end that would have an odd number. not really sure what to do

 

[sandy666]

Much more fun with Power Query
let in Table.Pivot(Table.Skip(Record.ToTable(Table3{0}),2), List.Distinct(Table.Skip(Record.ToTable(Table3{0}),2)[Name]), "Name", "Value")

Column1	Column2
10000	1400
Custom.1	Custom.2	Custom.3	Custom.4	Custom.5	Custom.6	Custom.7	Custom
1400	1400	1400	1400	1400	1400	1400	200

the morning is wiser than the night ?

 

[sandy666]

not wiser