Normally to add columns using SQL I would use the Alter Table statement. However, it looks like ZOHO only allows Select functions.

I have a row of Estimator Names, and a corresponding row of Job Amounts and a row of Job ID's.

What I would like to do is ADD dedicated columns for each estimator that includes the job Amounts for those rows. Example of desired result below

A suggestion would be very appreciated

Thank you