| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transposition of data
Hi,
I have some data in the column A of a sheet and in another sheet of the same file, I need to use the same data but horizontaly this time : I need that A2 in first sheet come in B1, A3 in C1, A4 in D1... And I don't want just the data, I need to this to update itself his the first data change. I have try to do in column a of the ne sheet A1 =A1, A2=A2... and the n copy it to do a pastespecial formula-transpose, but it doesn't work... Thanks for any hel Happy Christma Benjamin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Transposition | Excel Discussion (Misc queries) | |||
| Automating transposition exercise | Excel Worksheet Functions | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| Transposition impossibility? | Excel Discussion (Misc queries) | |||
| Transposition | Excel Worksheet Functions | |||
Threaded Mode
