Hi guys!
I have the following fields:
Account ID
Query ID
Data Value
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!