| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transpose cells skipping blanks
Hi there,
Could someone help me sort this one out. I have data in row 1 in 5 cells. lets say 1 2 blank 3 4 now I want to write a macro in which this row is transposed without blank cell, i.e., with 4 cells: 1 2 3 4 could someone help me please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Skipping Blanks (Again) | Excel Discussion (Misc queries) | |||
| Skipping Blanks | Excel Discussion (Misc queries) | |||
| Subtraction formula for consecutive cells in a column, skipping blanks | Excel Worksheet Functions | |||
| Skipping blanks | Excel Discussion (Misc queries) | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Threaded Mode
