How do I invert the data in c0 and place it in c1?

The following formula can be used to invert the data in c0 and place it in c1.

c1 = cell(n – index(), 0)

where n is the last row number in the data window, or the last row you want to have inverted. Any empty rows at the bottom of the original data will be placed at the top of the output column. These can be selected and deleted.

Scroll to Top