| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Transposing data
is their any other way of transposing the data rather than using copy, paste special and transposing. -- Vkhara ------------------------------------------------------------------------ Vkhara's Profile: http://www.excelforum.com/member.php...o&userid=35033 View this thread: http://www.excelforum.com/showthread...hreadid=547784 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Transposing data
1) Use TRANSPOSE function
2) Use INDEX function with indexes based on ROW() and COLUMN() 3) Write a VBA proc HTH -- AP "Vkhara" a écrit dans le message de news: ... is their any other way of transposing the data rather than using copy, paste special and transposing. -- Vkhara ------------------------------------------------------------------------ Vkhara's Profile: http://www.excelforum.com/member.php...o&userid=35033 View this thread: http://www.excelforum.com/showthread...hreadid=547784 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing Data using Offset function | Excel Worksheet Functions | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Importing Data | Excel Worksheet Functions | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Linear Mode
