Need a little help. Reference input and output examples below. I want to clean and concat (down).
UPDATED
INPUT:
| Year | State | Recipient |
| 2020 | CA | SDACQMD |
| National | | |
| 2020 | IL | ALA |
| National | IN | |
| | OH | |
| 2020 | FL | City of Ocala |
| National | | |
| 2020 | TX, MO, CA | Dominos |
| National | | |
DESIRED OUTPUT
| Program | Year | State | Recipient |
| National | 2020 | CA | SDACMD |
| National | 2020 | IL, IN, OH | ALA |
| National | 2020 | FL | City of Ocala |
| National | 2020 | TX, MO, CA | Dominos |
