Stack Overflow
Stack Overflow

Questions tagged [consolidation]

160 questions
1
vote
1 answer

Excel Macro: Copy Sheets from Multiple Workbooks WITH Added Refresh Capability

I am looking to merge sheets in multiple Excel files into one master file with refresh/update functionality. To be more specific, I have ~25 workbooks in one folder which are identical in structure and vary based on entity. Each file has one sheet,…
ERT
  • 719
  • 5
  • 16
1
vote
2 answers

How can I consolidate data between 2 different Workbooks?

I need to consolidate 2 students’ registrations between different workbooks (holding and subsidiary). So when I click the button “Generate Graphic”, the data are consolidated in the sheet “Total” and then, the number of courses (Excel, Word,…
Granado
  • 13
  • 2
1
vote
2 answers

Summing Multiple Columns By Date in SAS

I have data that looks like this in SAS; Date Type_1 Type_2 4/8/2015 21654.72 . 4/9/2015 34490.13 . 4/9/2015 32429 . 4/9/2015 . 24438.76 4/9/2015 . 54043.18 4/9/2015 . 58969.06 4/9/2015 . …
Jarom
  • 1,067
  • 1
  • 14
  • 36
1
vote
2 answers

consolidate columns that may or may not have overlapping data, using R

Let's say you have a data set that looks like this: Vietnam Gulf War Iraq War veteran1 1 0 0 veteran2 0 1 0 veteran3 0 0 1 veteran4 0 1 …
thanks_in_advance
  • 2,603
  • 6
  • 28
  • 44
1
vote
2 answers

How to set a SourceRange for multiple columns in xls?

I am trying to consolidate a data from multiple worksheets into one, using a master spreadsheet. However, it seems that I can only set a sourceRange for consecutive columns and I would like to copy different columns (e.g. A, C and K). Can someone…
IvanS
  • 19
  • 4
1
vote
1 answer

How to consolidate data before saving to database?

I have processes to retrieve CPU, memory, disk usage from a couple of machines and store data into MySQL database. I would like to draw them in line charts, like CPU usage vs. date or memory usage vs. date. After a couple of months, my database has…
talihsu
  • 175
  • 3
  • 13
1
vote
1 answer

Data consolidation using Columns

We sell our product via a number of different retailers. These shops send us reports of what they have sold and we need to import this into our new stock management system as a master file. The stores do not and will not provide the data in a…
Dinoshaw
  • 33
  • 2
1
vote
1 answer

consolidate function is not working in vba

What I need is really simple. for instance: Br 56 Bc 6 Bt 20 Br 23 bc 15 I want these duplicate bc/br/bt consolidate and sum their numbers This is the part of…
Nefer Zhang
  • 11
  • 1
  • 7
1
vote
1 answer

Header in Transformation File (SAP BPC) getting evaluated even when not desired

I am facing an issue with my flat file. The BAdI is processing the header data as the body of the flat file. Due to this, the TIMEID, which is conditioned to be an year belonging to 'Q1', is giving the error. If I replace the TIME label with 2014.Q1…
Ruchir Saxena
  • 29
  • 5
1
vote
2 answers

ANY way to consolidate this code?

I am building a PHP registration form which takes the following fields for up to 20 athletes: First Name Middle Initial Last Name Federation Number Address City State Zip DOB SSN Phone Email I am only through 7 of the fields for each fighter…
JM4
  • 6,740
  • 18
  • 77
  • 125
1
vote
1 answer

Excel dynamic array formula

I have a workbook with 11 sheets for each month, and one summary sheet. On each sheet is a list of website in column A between A2 and A13, and in column B are some values taken from those website. The individual Month sheets look something like…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
1
vote
4 answers

Condensing repeating JQuery code

I have a page that has a large image on it with a number of thumbnails. When you mouse over a thumbnail the main image changes to the image you have just rolled your mouse over. The problem is the more thumbnails I have, the more repeated code I…
Craig Ward
  • 2,425
  • 5
  • 33
  • 51
1
vote
2 answers

Google-Bigquery: consolidate aggregate

I'm trying to create a query which does something a little complex, and I haven't been able to find anything that might point me in the right direction. Perhaps YOU can help! This is the source data: 7457, "05:06:26 UTC", 15 7457, "05:06:26 UTC",…
cowlinator
  • 7,195
  • 6
  • 41
  • 61
1
vote
1 answer

Creating customer_id based on matchcodes in Oracle (SQL)

I have an oracle database containing purchases of customers. (one record is one purchase) Customers provided their personal data again and again at every purchase. So there can be differences due to mistype, address change, etc. Now I have to…
Viktor
  • 121
  • 6
1
vote
1 answer

Condensing combinations for betting (1X2) in Python

I am having some trouble reaching my goal of reducing coupons for betting in python. I am trying to reduced rows of bets in 1X2-form to combined coupons. Since the rows are generated by another software they come as single rows and not combined ie.…
dinc
  • 21
  • 3
1 2
3
…
10 11