Divide by line

[kauser]

Hello, 

can you please show me how to Divide line 1 and 2 from each column 

Input Data 

A	B	C
6	15	50
3	5	10

Expecting Data

A=2,B=3,C=5

[flying008 · Accepted solution]

Hi, @kauser 

FYI.

[Pilsner · Accepted solution]

Hello @kauser,

It looks like @flying008's has already provided a great solution, just thought Id share how Id go about this problem too.

Firstly, I would add a record ID to my data. This is usefull as it acts like a lable so we know which line to divide by.

Next, I transposed my data, making sure to mark the record ID as a key column.

After this, you can cross tab your data back, but this time, group by the name field and make the Record ID the column headers.

Finally, with your original lines now represented as columns 1 and 2, you can simply use the formula tool to divide one by the other.

 

I have attached the worklfow below so please feel free to try it out yourself. Please let me know how you get on.

Regards - Pilsner