Solved

Single Line Item Display

Posted on 2011-09-19
2
285 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:ablove3
2 Comments
 
LVL 12

Accepted Solution

by:
sdwalker earned 250 total points
Comment Utility
I did it through code.

Good luck,

sdwalker
Job-Group-Data-sdw.xls
0
 

Author Closing Comment

by:ablove3
Comment Utility
That works perfectly.  Thank you very much
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now