| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TRANSPOSE: getting 0es but waste cells wanted
Hi
I have mixed content with zeroes and spaces in the source range. The TRANSPOSE function returns zeroes only in place of empty cells. How should I fix it? TIA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=TRANSPOSE: getting 0es but waste cells wanted
One possible solution: replace the blank cells with an apostrophe.
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "LevT" wrote: Hi I have mixed content with zeroes and spaces in the source range. The TRANSPOSE function returns zeroes only in place of empty cells. How should I fix it? TIA |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=TRANSPOSE: getting 0es but waste cells wanted
Here's an alternative method: http://www.mrexcel.com/archive/Edit/3118.html
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Dave F" wrote: One possible solution: replace the blank cells with an apostrophe. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "LevT" wrote: Hi I have mixed content with zeroes and spaces in the source range. The TRANSPOSE function returns zeroes only in place of empty cells. How should I fix it? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose from one sheet to the next and leave out blank cells | Excel Discussion (Misc queries) | |||
| transpose data between columns, rows or cells | New Users to Excel | |||
| How to transpose a long list of text across cells | Excel Discussion (Misc queries) | |||
| transpose 3d cells to a column in single workbook | Excel Discussion (Misc queries) | |||
| list 3 things to minimise waste and conserve energy and resour... | Excel Discussion (Misc queries) | |||
Linear Mode
