Single Line Item Display

I have a list of Job Codes and some job codes have several census codes.  This list displays the 5 different line items if there are 5 different census codes.  How can I get the data to display only one line item.

Example

Code     Census Code
AB               11
AB               102
AB               103



How can it look like this

Code     Census #1    Census #2   Census  #3
AB               11              102               103



Job-Group-Data.xls
ablove3Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sdwalkerConnect With a Mentor Commented:
I did it through code.

Good luck,

sdwalker
Job-Group-Data-sdw.xls
0
 
ablove3Author Commented:
That works perfectly.  Thank you very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.