Column Data to Rows

[Ken]

I have a long string of data in column A from cell A1 to A1000. The data is
dynamic. I want the data to also be shown in Row 1 beginning in cell C1 and
continueing right (for 1000 cells). I.e. cell C1 would be "=A1", D1 would be
"=A2". All of the data needs to be dynamic, just the same as the original
data listed in column A. The transpose function seems to only work for real
data and not formulas. Can anyone show me a shortcut to do this correctly?

 

[Farhad]

Hi,

Try this:

in the cell C2 enter =A1 and copy drag down the cell c2 to cell C1001 now
the cells C2:C1001 should be selected (if not select them) go to Edit>
Replace and put A in find box and $A$ in replace box and then click Replace
All then right click on selected cells (C2:C1001) and choos copy then right
click on cell C1 and choos past special and check transpose and click ok.

Thanks,