wonder if there's an easy way to duplicate rows in excel. An example would be:
Before:
1
2
3
4
after:
1
1
2
2
3
3
4
4
I meet this issue way to often to cut/paste my way down.. Anyone have a trick or two?
Suggest you do an sorting your first result-set that includes each of your columns, e.g.
Sort By Column A
Then By Column B
Then By Column C
...etc
This might give you something like:
1 A X
2 B Z
3 C Y
4 D T
Then you can copy the result set and paste it immedately below your first:
1 A X
2 B Z
3 C Y
4 D T
1 A X
2 B Z
3 C Y
4 D T
Then you would sort it again
1 A X
1 A X
2 B Z
2 B Z
3 C Y
3 C Y
4 D T
4 D T
Initial state, many rows, many columns :
... ... ...
... ... ...
... ... ...
In an extra column, you add numbers from 1 to the number of rows :
... ... ... 1
... ... ... 2
... ... ... 3
Copy-paste the whole block below itself :
... ... ... 1
... ... ... 2
... ... ... 3
... ... ... 1
... ... ... 2
... ... ... 3
Order according to the last column :
... ... ... 1
... ... ... 1
... ... ... 2
... ... ... 2
... ... ... 3
... ... ... 3
You may now remove the extra column.