Stack Overflow
Stack Overflow

Questions tagged [consolidation]

160 questions
0
votes
1 answer

Consolidating data based on two conditions

I have four columns of data that I am trying to consolidate based on two conditions. The data are formatted as follows: CountyName Year Oil Gas ANDERSON 2010 1358 0 ANDERSON 2010 621746 4996766 ANDERSON 2011 1587 …
tda0715
  • 11
0
votes
3 answers

R: Consolidating duplicate observations?

I have a large data frame with approximately 500,000 observations (identified by "ID") and 150+ variables. Some observations only appear once; others appear multiple times (upwards of 10 or so). I would like to "collapse" these multiple…
HAL-9000
  • 99
  • 2
  • 9
0
votes
1 answer

Copy data from multiple workbooks in a folder into one workbook paste special only value

I want to Copy all sheets of multiple workbooks within a folder into another single workbook. I found below code but do not know how to paste special only values to avoid unnecessary formatting. Sub GetSheets() Path =…
mechee69
  • 15
  • 1
  • 6
0
votes
1 answer

SQL Group By existing rows, Delete them, and Insert Group By results

I'm trying to figure out a way to reduce the size of a table that is growing to an alarming size by consolidating similar entries. I've gotten a working 'Group By' query that does roll up the data as I would like, I'm just not sure how to delete…
user3027875
  • 101
  • 8
0
votes
2 answers

How to consolidate duplicates in Excel where several columns need to remain uncosolidated

I am trying to do a stock count through product stores but have several part numbers that are listed twice (Column A). When I try to consolidate these I recieve the error 'no data consolidated' which I think is caused by Columns B-F (which will…
ellie
  • 11
  • 1
  • 1
  • 4
0
votes
1 answer

TFS 2015.4 consolidation path

I have 2 different tfs servers, on different machines. Both of them is not in any domain. Each of them has their own project collections and team projects. What I wanna do is merge them on a new server. What I believe this is called consolidation.…
Tolga Evcimen
  • 7,112
  • 11
  • 58
  • 91
0
votes
1 answer

How to consolidate duplicate elements of this array in PHP?

I have an array like this: $array = array( 0 => array("ordernumber" => "1", "name" => "John", "product" => "laptop", "component" => "memory"), 1 => array("ordernumber" => "1", "name" => "John", "product" => "laptop", "component" => "cpu"), …
Marc
  • 229
  • 3
  • 14
0
votes
1 answer

Consolidation of data sheets onto one worksheet

I have a workbook with about 14 worksheets. A selected set of worksheets contains the data which will be updated. They need to stay separated for the users. To summarize this data to produce a report, I need to combine all the data sheets (all in…
kitarika
  • 175
  • 1
  • 12
0
votes
1 answer

Combine Sheets from different workbooks with the same names into a master workbook

so I have about 21 sheets that are all named the exact same across about 16 files. All the formats and such are the exact same, so for example I need to combine all the sheets with "Age" in all 16 files into a master file that will have the "Age"…
ThePangloss
  • 31
  • 5
0
votes
1 answer

Consolidating Data from Other Workbooks into One Workbook

Current Situation: I am consolidating a data package that receives multiple inputs from programs that roll into mine. Essentially, each program provides me their set of data and I am responsible for accurately consolidating data into one Excel…
toddexcel
  • 1
  • 1
0
votes
2 answers

MySQL query to consolidate table

Can you help me create a query that will convert the 1st table (left) to the 2nd table (right). I need to consolidate the product codes to the Purchase Order. PO table:
major tsai
  • 1
  • 1
0
votes
1 answer

Error when consolidating like rows with plyr - what am I doing wrong?

I have a dataframe (dtetags.df) with a date column that has many duplicate dates: dtetags.df$Date "2016-07-22" "2016-07-22" "2016-07-21" "2016-07-21" "2016-07-20" "2016-07-20" "2016-07-19" "2016-07-19" "2016-07-18" "2016-07-18" "2016-07-15"…
arebearit
  • 15
  • 4
0
votes
2 answers

SQL Server : gather data from different databases

I have many different application databases with a [Log] table. I have one central database with a similar log table, but with one extra column called TenantId. There is also a Tenant table with a TenantId and a DatabaseName column. These…
Erik
  • 417
  • 4
  • 14
0
votes
2 answers

Combining tables with different number of columns, some in common with same header names

Hello. So I am working out of the query editor of a PowerPivot. I have two tables in the PowerPivot window, which I am editing with the query editor in the table properties tab. The tables have a different number of columns, some columns they have…
Brendan
  • 3
  • 1
0
votes
3 answers

Condensing vb.net code

I have the following code: Private Sub txtFileFromLocation_TextChanged(ByVal sender As System.Object, ByVal e As System.Windows.Controls.TextChangedEventArgs) MachineNameUIDisabled() ServiceNameUIDisabled() ToLocationUIDisabled() …
Jim
  • 3,425
  • 9
  • 32
  • 49
1 2 3
…
10 11