How to Normalize Outputs from Company Funding Waterfall Queries Using AI

Hey there again, I have yet another quick question. Any of you guys who have used the company latest funding waterfall, how do you deal with the different outputs? Sometimes I just get a massive (sometimes unrealistic) number, or I get a small paragraph, or a sentence based on what tool found the data in the waterfall. I'm thinking of adding an AI column to write a normalized output, but it seems to me I might have to map a lot of fields from the 4 different queries to get a proper output. Would love to hear how you guys have solved this in your workflows:)