| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I unmerge data in a column and distribute in rows?
I have data from an address base that when cut and pasted gourped or merged
three cells. I would like to unmerge them and distribute the information from 3 cells in a column to three cells in a row. I have 1400 addresses, so doing this manually is not logical. The "unmerge" command does not do anything. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| distribute rows from one workbook to other workbooks | Excel Discussion (Misc queries) | |||
| distribute data to every other cell | Excel Discussion (Misc queries) | |||
| How to randomely distribute non-numerical values across rows? | Excel Worksheet Functions | |||
| UNMERGE two cells/rows in Excel | Excel Discussion (Misc queries) | |||
| Can I Distribute Excel reports that retrieve Data-On-The-Fly ... | Excel Discussion (Misc queries) | |||
Threaded Mode
