Asi
06-13-2013, 12:40 AM
Hi
I have a table of Employees that has the following columns:
EmpID, Title, SubTitle.
Each Employee can have many Titles and some Titles can have many SubTitles. I refer to it as my "DB Sheet".
As you can understand, this table is in normalized form as usually done in SQL Server ( A row for each EmpID, Title, SubTitle). The reason for this is - I have a "Data Validation" criteria on the Title & SubTitle columns, the values are taken from a list , because I don't want them to be free text (I need it for pivoting later on).
What I want is to create a "Display Sheet" that will flat the data, meaning - A row for eac EmpID, Title and I want the SubTotal values to be concatenated.
For example:
If the "DB Sheet" has the following rows:
EmpID Title SubTitle 1 T1 ST11 1 T1 ST12 1 T1 ST13 1 T2 ST21 1 T2 ST22
I want the "Display Sheet" to look like this:
EmpID Title SubTitle 1 T1 ST11, ST12, ST13 1 T2 ST21, ST22
Any Ideas of how to aggregate & concatenate
I have a table of Employees that has the following columns:
EmpID, Title, SubTitle.
Each Employee can have many Titles and some Titles can have many SubTitles. I refer to it as my "DB Sheet".
As you can understand, this table is in normalized form as usually done in SQL Server ( A row for each EmpID, Title, SubTitle). The reason for this is - I have a "Data Validation" criteria on the Title & SubTitle columns, the values are taken from a list , because I don't want them to be free text (I need it for pivoting later on).
What I want is to create a "Display Sheet" that will flat the data, meaning - A row for eac EmpID, Title and I want the SubTotal values to be concatenated.
For example:
If the "DB Sheet" has the following rows:
EmpID Title SubTitle 1 T1 ST11 1 T1 ST12 1 T1 ST13 1 T2 ST21 1 T2 ST22
I want the "Display Sheet" to look like this:
EmpID Title SubTitle 1 T1 ST11, ST12, ST13 1 T2 ST21, ST22
Any Ideas of how to aggregate & concatenate