C1 Community

I have a need to hide duplicate values in several columns of data.  I suspect you would use RowMerge but I do not see how to make it do what I want it to do.

 I have data like the following:

 Product1    Lot1   ValueDescription1 Value1
 Product1    Lot1   ValueDescription2 Value2
 Product1    Lot2   ValueDescription1 Value1
 Product2    Lot3   ValueDescription3 Value3
 Product4    Lot4   ValueDescription1 Value1
 Product4    Lot4   ValueDescription2 Value2

I would like to have the following displayed:

 Product1    Lot1   ValueDescription1 Value1
                           ValueDescription2 Value2
                  Lot2   ValueDescription1 Value1
 Product2    Lot3   ValueDescription3 Value3
 Product4    Lot4   ValueDescription1 Value1
                           ValueDescription2 Value2

The RowMerge function does the merging but it puts the Merged values in the middle of the group of values instead of the top row of the merged group.  Can it be made to put it in the first row.  I guess I could do it with the more complicated Grouping but really think Merging should be able to do what I need.

 
Thanks

Mike Mattix

you can format the merged columns  (by opening the columns properties) and set the vertical-align

I knew it had to be something easy. 

 Thanks Michele!!

Mike