OK, one more today, hoping to finish this data output today.
I have to transpose this:
| Transaction Type | Benefit Month | code 5601 | code 5602 | code 5603 | code 5604 |
| TRN | 12/18/2018 | 175.5 | 48 | | |
| PRK-CR | 12/18/2018 | | | 50 | 0 |
Into this:
| Transaction Type | Benefit Month | | |
| TRN | 12/18/2018 | code 5601 | 175.5 |
| TRN | 12/18/2018 | code 5602 | 48 |
| TRN | 12/18/2018 | code 5603 | |
| TRN | 12/18/2018 | code 5604 | |
| PRK-CR | 12/18/2018 | code 5601 | |
| PRK-CR | 12/18/2018 | code 5602 | |
| PRK-CR | 12/18/2018 | code 5603 | 50 |
| PRK-CR | 12/18/2018 | code 5604 | 0 |
I can transpose the data fine but I can't figure how to get the "code" field headers to be included in the new rows.