Hi, I have a long vertical list of values (A1, A2, A3,....) . I want to report these values horizontally, in cells B1,C1,D1,.....
The only way I know is to type =A1 in cell B1, =A2 in cell C1 and so on, which will waste several hours of my time (this situation keeps coming up repeatedly as well.) Transpose is not keeping the formulae absolute, so any ideas to do this faster?
The only way I know is to type =A1 in cell B1, =A2 in cell C1 and so on, which will waste several hours of my time (this situation keeps coming up repeatedly as well.) Transpose is not keeping the formulae absolute, so any ideas to do this faster?