I need some help here, i want to create a Pivot table to display the output i want.
here is my database table:
View attachment 227906
I want it to display
clientid | lastname | firstname | Job 1 | Amount | Job 2 | Amount
283641 Rey Ann 04-18-2017 268.00 07-11-2016 708.00
Where Job Columns are dynamic which holds the date of the job and the amount is also dynamic that holds…