As I am a newbie when it comes to Excel (and the entire Microsoft Office suite, to be honest), I spent a lot of time browsing for a solution to this issue – how to get a one-to-many rows table out of a normalized table – and since I'm posting this, it's obvious I didn't find a proper answer.
To be more clear, say the initial normalized table is the one presented below:
And the resulted table should look like this:
Now, for a table with a few rows, the answer is quite obvious and a bit inefficient:
- Sort the column which contains cells with same value;
- Manually select the groups of cells with same value and right click on 'Merge & Center' button (see picture below).
- Repeat Step 2 for all of the identified groups of duplicated cells within that column.
The challenge is to obtain the same result for a table with large ammount of data (~6k rows), using Excel 2010. Obviously, the solution presented above is far from being efficient.
Any thoughts on this? I would really appreciate your help.