| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Using data in rows in a table in columns.
one way:
=INDEX(Sheet1!$2:$2,ROW()+1) In article , Andy wrote: I have a series of data in rows (eg. in cells B2, C2, D2, E2...). I want to pick these values up and use them else where in a table arranged in columns. Therefore the formula in the first row (cell B2) will be =Sheet1!B2, the second row (cell B3) will be =Sheet1!C2, the third row (cell B4) will be =Sheet1!D2 etc. If I copy or drag the formula down the rows I end up with the incorrect references (the row value increments, but not the column value) as you would expect. Is there any way to drag down or copy the formulas to pick up the data as I have tried to describe above? - or do I have to enter the formula for each cell? Thanks, Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I rotate data in Excel table (rows to columns, and vv)? | Excel Discussion (Misc queries) | |||
| Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
| Change data to appear in rows instead of columns (reverse a table. | Excel Discussion (Misc queries) | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
Threaded Mode
