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 |
Solved! Go to Solution.
Similar solution to @apathetichell but potentially more flexible depending on the variety of recipients and programs in your data set.
Both solutions work. The first solution does what I originally asked. The second solution works better for my particular use case (and my revised question). Thank you both.