The easier a space is to fill, the sooner the numbers come back to you. A vendor contract needs its active months and its cost. Until now, each of those variables took a row of its own: the same vendor repeated down the table, and the number you wanted to change buried among rows that all looked alike.

One click in the input table's setup turns on Pivot variables, and the table turns around. Items become the rows, variables become the columns. Your contributors choose the vendor once and fill in its dates, its cost, and anything else across that single line, then read the whole thing back in one go.

Learn how to set up a pivoted input table