Distribute column A to 26 columns of integer value

Hello! I'm new here. I dont have any macro or VBA knowledge so I ask your help.

I need to distribute values from column "E" to next 26 columns.
Column E contains integer values (number of products), and I want to distribute them to 26 stores.
If the number of products is not divisible by number of stores (26) the first stores have priority to receive the products remaining.
Hope I made myself clear, I'm not a native englist speaker.

Your help is highly appreciated.
Thank you!

Thanks for quick answer.
Here it is, in yellow is the column I need to divide.

=IF(COLUMN(F$1)-5<=$E2-INT($E2/26)*26,INT($E2/26)+1,INT($E2/26))

in E2 and copy both ways

Thanks for the input AlanY, but the formula contains an error.
I cannot do a reverse engineering so I can fix it, but I attach 2 printscreens.
I assumed I have to enter it in F2....AE2, since the E column must remain unchanged. That is the column where I take the values to distribute.

you're welcome.

did you replaced the , with ; as zbor suggested to make it works?

yes. I should have thought of that before crying for help again.....

work for me, see attached

IT WORKED!!

Thank you both gentlemen! You saved my day.

The key to human success is learning from each other.

Have a great day.

usefull info! thanks