score:0
you should be able to post images here on stackoverflow.
anyways; will a pivottable
do the job for you? mark the data and then insert -> pivottable
. you are working in excel, right?
Source: stackoverflow.com
Related Query
- Consolidate data for weeks to months and quarters, weeks are like W1, W2 and not in date format
- is it possible for VBA to detect the error and give a prompt that data not available instead of giving error message?
- How to write code to test a cell for specific data, and if that data is present, don't run the macro. If not present, then run macro?
- Is there a VBA function like IsNumeric but for Text? IsText and IsEmpty not working the same when a range is involved
- VBA how to use * as a character and not wildcard for cell.formula like
- formatting codes for footer not being applied and page orientation data mismatch
- What VBA code options are there to group data into time buckets, copy it to another sheet, and loop for multiple parts (criterion)
- For loop in VBA misbehaving, and not running the way I would like
- For loop in VBA misbehaving, and not running the way I would like
- Time durations are not obeying [h]:mm:ss format for all data values
- VBA code for excel - delete rows that contain only capital letters, data is not like
- VBA - If condition met, check for value first in another sheet's range. If matching, return set value and if not then append data to new row
- VBA or to not VBA for compare and count cell data with unique ids
- chart series names are not shown until select data in right click menu is clicked and another series is selected
- Macro to consolidate data from 2 different worksheets of each wkbook inside subfolders and show result in separate worksheets for each subfolder
- How to consolidate data of Specific columns from multiple sheet to one sheet using excel macro when the required columns are not in same order
- Create Chart from Array data and not range
- Code for looping through all excel files in a specified folder, and pulling data from specific cells
- I want data of 50 random array with 5 column and 10 row, with unique and no duplicate value. Here why duplicate values are showing?
- What are the units for form widths and heights in VBA?
- Error importing and exporting excel data to vb.net, "Microsoft.Office.Interop.Excel.Application is not defined"
- Create a new sheet for each unique agent and move all data to each sheet
- What are the limits for ADO data types?
- Query and/or function that subsets the data on one field for all types and calcs on other field
- Error in VBA:`[Microsoft][ODBC Manager] Data source name not found and no default driver specified
- Using VBA to find start value, count rows till that value becomes 0 and record result. Repeat for same column until the end of the data reached
- Excel VBA: Macro for data processing getting slower and slower the longer it runs
- OLEObject Height and Width are not consistent
- Google Maps API for Time and Distance Data (Access/VBA)
- Sending and receiving data via POST in Microsoft Word 2011 for OSX
More Query from same tag
- Find column with specific name and fill the field with specific text to the last row
- Excel VBA - Create a new row every 1200 rows
- How to auto forward, an email with attachments from sender, to more than one email address?
- Use INDEX/MATCH to select formula written as string, and enable it?
- How to dump data to a workbook and save a copy?
- VBA: Runtime error 438
- Excel VBA to Delete Rows with Zeros, Wrong Operator?
- Group Values in excel according duplicate value in column
- Sort a table with protected sheet
- Show progress of HTTP Request in MS Access
- Why use arrays in VBA when there are collections?
- Excel VBA: Stops Working at Outlook Email Creation Subroutine
- Wait for ExecWB to finish
- Save documents with the data from mail merge
- VBA Spellcheck, highlight cell with misspelled word
- Iterating over all pivot table objects
- Count mixture of cells and merged cells
- How can I subtract the seconds from a timestamp which is double?
- How can I prevent an Excel Combo Box from displaying duplicate entries and/or spaces?
- Extend ActiveCell-Range with LastRow
- Worksheet Function Max with condition
- Testing for an Application level dialog in Excel 2010
- excel merged cells copy paste issue
- Accessing a form control inside a group box on the sheet
- Is initial save to local drive more resilient than using network drive
- Obtaining visible data from filtered table
- Check if couple of ranges are met in worksheet
- VBA Access removing hard coded file paths
- VBA program to convert table to ARFF returns "User-defined type not defined"
- Create a list of majority values