I have the following fields:
I want to create a table which will have the following columns:
Account ID, Data Value (where Query ID=1), Data Value (where Query ID=2), Data Value (where Query ID=3)....
Any idea how this can be done by using a calculated field?
Thanks for your help!
Retrieving data ...