Column format

Copper Contributor

I want to make Column C follow the format of column A.

 

From this:

A B C D E
X    X
      X
X    X
X    X
  
X

 

To this:

A B C D E
X    X
      
X    X
X    X
 
X    X

Though moving the cells down manually would be very tedious, so is there a way to work this via formula?

1 Reply

@RMofMWHD 

 

=IF(A2="","",INDEX($C$2:$C$5,COUNTA(A$2:A2)))

 

Then, copy and paste value