Intelligence Suite

[samxhander09]

Hi community,

I am very new to Alteryx Intelligence Suite. I have 16 pages of PDF and im trying to parse specific info. I have highlighted the info I want to output.

My problem is, I have input where there's an additional data, example for Department of National Zoo and Defense, there is a data for Monthly Income to be added to weekly, but for National Daycare there's none. And there's 16 departments, no way to tell what dept's gonna get the monthly income by next report. How can I make this possible? How can I parse? I have attached an example of my desired output.

Thank you, help is very much appreciated.