Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Data to Rows
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? -- Ken |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Data to Rows
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, -- Farhad Hodjat "Ken" wrote: 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? -- Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting all rows of data that have a value in a particular column | Excel Discussion (Misc queries) | |||
Formatting Rows of Data based on Column Data | Excel Worksheet Functions | |||
Column Data to Rows | Excel Discussion (Misc queries) | |||
Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) |