Rows to Columns

[dcjames]

I have a crosstab query based on 3 oracle tables. Based on another thread I have set the following options

1). Set Summarized field to Max for the column
2).Under Customized Style Selected "Suppress Row Grand Totals" and "Suppress Column Grand Totals"
** Group Name is being used in the column...a user could be a member of 1 or many groups **

I also have the following record selection forumla defined:
{USR.USR_STATUS} = {?Status} and

(if{?Business_Segment} = '*' then
({USR.USR_UDF_ORGANIZATION} like '*' or isnull({USR.USR_UDF_ORGANIZATION}))
else {USR.USR_UDF_ORGANIZATION} = {?Business_Segment})

and

(if{?Location_Code} = '*' then
({USR.USR_UDF_LOCAT_CODE} like '*' or isnull({USR.USR_UDF_LOCAT_CODE}))
else {USR.USR_UDF_LOCAT_CODE} = {?Location_Code})

and

(if{?Division_Code} = '*' then ({USR.USR_UDF_DIVISION_CODE} like '*' or isnull({USR.USR_UDF_DIVISION_CODE}))
else {USR.USR_UDF_DIVISION_CODE}= {?Division_Code})

and

(if{?Job_Code} = '*' then ({USR.USR_UDF_JOB_CODE}like '*' or isnull({USR.USR_UDF_JOB_CODE}))
else {USR.USR_UDF_JOB_CODE} = {?Job_Code})

and

(if{?Department_Code}= '*' then ({USR.USR_UDF_DEPARTMENT_CODE} like '*' or isnull({USR.USR_UDF_DEPARTMENT_CODE}))
else {USR.USR_UDF_DEPARTMENT_CODE}= {?Department_Code})

When running the report I see all possible columns across the screen/sheet

UserID group1, group2, group3,group4,group5,etc.......| User ID group1 group2, group3, group4, group5,etc....

All I want to do is change the group names from appearing as a list to a column

Any help is appreciated