Hi,
I want to merge common cell values to single cell(like row span)
My Data:
UserName Name Date
------------------------------------------
user somename 1/12/12
user somename 2/12/12
user somename 3/12/12
user somename1 2/11/12
user somename1 3/11/12
user somename1 4/11/12
user somename2 6/12/12
user somename2 7/12/12
user somename2 5/12/12
I want like this
UserName Name Date
------------------------------------------
1/12/12
somename 2/12/12
3/12/12
2/11/12
user somename1 3/11/12
4/11/12
6/12/12
somename2 7/12/12
5/12/12
I want to merge common cell values to single cell(like row span)
My Data:
UserName Name Date
------------------------------------------
user somename 1/12/12
user somename 2/12/12
user somename 3/12/12
user somename1 2/11/12
user somename1 3/11/12
user somename1 4/11/12
user somename2 6/12/12
user somename2 7/12/12
user somename2 5/12/12
I want like this
UserName Name Date
------------------------------------------
1/12/12
somename 2/12/12
3/12/12
2/11/12
user somename1 3/11/12
4/11/12
6/12/12
somename2 7/12/12
5/12/12