Right-Aligning Data to a Column
Hi,
I have several rows of numbers with each row containing between 1 and 20 columns of numbers.
I'd like to "right-align" the rows of numbers so that the last number in each row are aligned with each other. In other words, alignment is right-to-left, not-to-right.
Example:
C1 C2 C3 C4 C5 C6 C7
R1 5 6 7 5 4 3
R2 3 2 3 1 4
R3 8 9
R4 2 1 2 6
I'd like 3, 4 9, 6 to align under C7 and their predecessors to align in the cells preceding behind them.
thank you,
sunnyside
|