thanks for the reply and the link although i have viewed that already but thanks all the same. so is there no way in data warehouse of grouping a single customers data to one row?