Closed:How to calculate read frequency from read counts for each gene in all samples all at once

Question

[vkgaur25]

I have a biological data with read counts in many samples. It looks like this snapshot of the format of data in excel-

I want to calculate the frequency of each gene in each sample. Mathematically obviouslly, I want each row to be divided by it's column sum but I am confused about how to do it all at once? I want a new sheet with same format but with frequency of each gene rather than count. Kindly help. Sorry for deviating from bioinformatics here .