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
somename 7/12/12
5/12/12
when we using grouping it will display all the names. but we need only one name(User have 9 times but we need to display one time)
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
somename 7/12/12
5/12/12
when we using grouping it will display all the names. but we need only one name(User have 9 times but we need to display one time)