KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have been given a fairly large database stored in Microsoft Excel, which I have to try convert into something useful. However, one of the problems that I am encountering is that some of the data is merged together (horizontally in 2s). For example; row 1: [ x ][ x ][ x ][ x ][ x ] row 2: [ x ][ x ][ o o ][ x ] row 3: [ o o ][ x ][ o o ] Where x's are single cells and o's are merged together What I want to do is unmerge all the rows (which I could do fairly easy with the unmerge button), but for where the merged cell was, have the data duplicated across the 2 cells. From; [[ Some Data ]] To; [ Some Data ][ Some Data ] Thanks! Any help is appreciated.
Tags (comma-separated)
Save Edits
Cancel