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 |
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) |