| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the rows to the columns
Hi,
Thanks. Tried that but realised that I actually need the data to be updated in the original table. Is there a way to update the transposed data wen the original data is changed? "oldchippy" wrote: Hi Nikki, Copy your range of data, then in a different cell say F1 Paste special Transpose oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=568798 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change a Column list into multiple rows & columns | Excel Worksheet Functions | |||
| How do change rows to colums AND columns to rows | Excel Discussion (Misc queries) | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| How to reverse order of rows and columns | Excel Discussion (Misc queries) | |||
| Is it possible to have rows labled A->Z and columns 0->n ? | Excel Discussion (Misc queries) | |||
Threaded Mode
