Need help converting the data in a table below (table 1) to (table 2), similar to a pivot table function in Excel. Thanks in advance.
Table 1
Account Name | Amount | Month |
GL 1 | 5 | Jul |
GL 2 | 10 | Jul |
GL 3 | 20 | Jul |
GL 1 | 15 | Aug |
Table 2
Account Name | Jul | Aug |
GL 1 | 5 | 15 |
GL 2 | 10 | etc. |
Thanks - how are you configuring this?