Looking for help comparing the same columns across multiple rows

[csh8428]

I have a history data-set of project data with many columns.  Each project gets 1 row of  history written once per day. I'm trying to build a "what changed"  report for each column that compares that column's value to the previous day's value. I know I could use the multi-row formula tool, but there are A LOT of columns so I'd rather not have to write one for each column.

Is there a way to write the same multi-row formula tool for every column without having to do it manually? Is there another way other than multi-row formulas?

The screenshots show sample data with the changes highlighted along with a sample output. I've attached a sample input file with the same data as the screenshot

Thanks for any help

[Luke_C · Accepted solution]

Hi @csh8428 

I'd suggest transposing the table and using a multi-row formula, then cross-tabbing back. See attached, let me know if you have any questions.