Solved

Help with spreadsheets with Data Summary and Drill down tables

Posted on 2014-11-18
7
92 Views
Last Modified: 2014-12-15
Greeting Experts,
      I deal with multiple spreadsheets that use Data Summary and Drill down tables “format” from McAfee EPO. The Data Summary gives me name of the Threats and number of times it was detected. Drill down tables gives a record (i.e. row for each one) of each time McAfee detected and deleted viruses... The drill down tables starts with the first row in Data Summary (i.e. 400 detections of one type of virus) and then steps down in sync with each type of virus until it down…. I looking for software that would help me combine both the Data Summary and Drill down Table in to one spreadsheet (i.e. applying the Summary Data to every row indicated in Drill down tables.  Can somebody help me with this.
0
Comment
Question by:amstoots
  • 2
  • 2
7 Comments
 

Author Comment

by:amstoots
ID: 40450800
Thanks......
0
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40452041
can you perhaps upload a dummy example?
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40496747
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0
 

Author Closing Comment

by:amstoots
ID: 40496748
Thanks for your help
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40499862
amstoots,

did you accept my comment by mistake?

i do not see a solution.  i have requested you for a dummy example.

is your question resolved?
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
A brief introduction to what I consider to be the best editor for PowerShell.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

840 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