+ Reply to Thread
Results 1 to 5 of 5

Need an efficient way to condense thousands of rows of excel data.

  1. #1
    Registered User
    Join Date
    03-01-2020
    Location
    Cardiff, Wales
    MS-Off Ver
    16.33
    Posts
    2

    Need an efficient way to condense thousands of rows of excel data.

    I'm trying to organise a large amount of data that needs to be analysed for my dissertation. The data in excel is about 32,000 rows with many repetitive rows that need to be summed together. There is a lot of other data in it as well which means a lot of the techniques I have tried haven't been working. Doing it all manually is pretty much impossible given my deadline so I was wondering if there are any ways to summarise that I'm not thinking of. I need to condense it based on site number and month. Each taxon_count also needs to be summarised for each order type. I have attached examples below. Thank you in advance!!

    If you're looking at the excel file I need an efficient way of turning sheet 1 into sheet 2.
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Need an efficient way to condense thousands of rows of excel data.

    Hi and welcome
    are you using a Mac version?

  3. #3
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Need an efficient way to condense thousands of rows of excel data.

    =sumproduct(Sheet1!$H1:$H33000,--(Sheet1!$F1:$F33000=D$1),--(year(Sheet1!$C1:$C33000)=$C2),--(month(Sheet1!$C1:$C33000)=$B2))
    Last edited by tim201110; 03-01-2020 at 01:16 PM.

  4. #4
    Registered User
    Join Date
    03-01-2020
    Location
    Cardiff, Wales
    MS-Off Ver
    16.33
    Posts
    2

    Re: Need an efficient way to condense thousands of rows of excel data.

    Yes I am using a Mac version

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Need an efficient way to condense thousands of rows of excel data.

    Then please add that to your XLversion in your profile.
    I will move the thread to the proper sunforum

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Merge Thousands of CSVs with Same Data Structure into 1 Sheet by Rows
    By EvilHidden in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-24-2019, 09:22 AM
  2. [SOLVED] How to condense data to single rows on a different sheet
    By dvess11 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-11-2019, 08:09 PM
  3. Condensing thousands of rows of user data using dates
    By ShamanWolf in forum Excel General
    Replies: 3
    Last Post: 03-17-2019, 05:54 AM
  4. How to delete thousands of rows of nothing below my data?
    By jeremiah89 in forum Excel General
    Replies: 13
    Last Post: 06-07-2013, 01:10 PM
  5. Replies: 4
    Last Post: 11-09-2012, 01:17 PM
  6. macro to condense rows of data to single row
    By lax in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2009, 06:21 PM
  7. [SOLVED] Can Excel "slide up" rows with content thru empty rows to condense
    By portly44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1