Multi Field Formula Question

[ltheiss99]

Hi,

The excel sheet I am uploading has 100 columns that each need to be divided by it's respective column

The set up right now is columns 1-100 are the numerators and columns 101-200 are the denominators so the formula would be along the lines of:

field 1 / field 101 = new column A

field 2 / field 102 = new column B

field 3 / field 103 = new column C

etc.

I'm wondering if there is a better way to do it than manually entering all 100 formulas - maybe by utilizing the multi field formula?

Attached is an example of how my data is set up in Excel

Thanks,

Lauren

[neilgallen]

A more direct route would be to transpose the data and then either cross tab and sort it by type then create the ratio, or use a multi row formula to get the desired effect.

[rafalolbert · Accepted solution]

Hi @ltheiss99,

Here you go:

Thanks,

Rafal

#Excuse me, do you speak Alteryx?