| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to change coloum to row
hi
in one of my application i need to change my colum data to row data is there any formula to resolve this i had tried TRANSPOSE option but i had not able to do it please help me to over come this problem thanks in advance regards sangeet |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to change coloum to row
When you did transpose did you copy just the data in the column or the entire
column? "sangeet" wrote: hi in one of my application i need to change my colum data to row data is there any formula to resolve this i had tried TRANSPOSE option but i had not able to do it please help me to over come this problem thanks in advance regards sangeet |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to change coloum to row
Are you changing a single column to a single row? What are from/to ranges?
Copy=Paste Special=Transpose should work. "sangeet" wrote: hi in one of my application i need to change my colum data to row data is there any formula to resolve this i had tried TRANSPOSE option but i had not able to do it please help me to over come this problem thanks in advance regards sangeet |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to change coloum to row
Sangeet,
Only copy the data you want to transpose not the entire column or you will get an error. Mike "sangeet" wrote: hi in one of my application i need to change my colum data to row data is there any formula to resolve this i had tried TRANSPOSE option but i had not able to do it please help me to over come this problem thanks in advance regards sangeet |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to change coloum to row
if the column has equations which use relative and not absolute references,
the paste special transpose will give you problems. give an example of the ytpe of data you want to transpose and from where to where, and we can probably give some suggestions. "sangeet" wrote: hi in one of my application i need to change my colum data to row data is there any formula to resolve this i had tried TRANSPOSE option but i had not able to do it please help me to over come this problem thanks in advance regards sangeet |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to change coloum to row
i had tried TRANSPOSE option but i had not able to do it ..
Assume you are trying to make a dynamic transpose of Sheet1's A2:A4 in Sheet2's B1:D1 using TRANSPOSE In Sheet2, Select B1:D1, then put in the formula bar: =TRANSPOSE(Sheet1!A2:A4) Array-enter the formula by pressing CTRL+SHIFT+ENTER (instead of just pressing ENTER) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "sangeet" wrote: hi in one of my application i need to change my colum data to row data is there any formula to resolve this i had tried TRANSPOSE option but i had not able to do it please help me to over come this problem thanks in advance regards sangeet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regonise coloum A while adding up coloum B to give a result in C | Excel Discussion (Misc queries) | |||
| how do i count the number of cells used in a coloum? | Excel Discussion (Misc queries) | |||
| Identify duplicate coloum A cells, and merge their row and text in | Excel Discussion (Misc queries) | |||
| Need to import data to a coloum not a row | Excel Discussion (Misc queries) | |||
| Chart Coloum Labels - Very Urgent | Charts and Charting in Excel | |||
Linear Mode
