| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unmerge cells and fill duplicate data
On Sunday, January 13, 2013 11:28:20 PM UTC+2, wrote:
Add another column (B) and then add this function to fill in everything until another entry for the merged cell in col A: =IF(A2=0,B1,A2). This assumes you have one header. For two or more rows, this will not work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Merged Cells and Unmerge Spread Merge Data To All Cells | Excel Programming | |||
| MACRO - Unmerge cells and delete blank columns, leaving data colum | Excel Programming | |||
| Unmerge cells and place contents of first cell in all cells | Excel Programming | |||
| How do you unmerge cells? | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Threaded Mode
