+ Reply to Thread
Results 1 to 2 of 2

Helping with Splitting Large Dataset into Tabs

  1. #1
    Registered User
    Join Date
    12-14-2017
    Location
    Washington, USA
    MS-Off Ver
    Office2016
    Posts
    1

    Helping with Splitting Large Dataset into Tabs

    Hi,

    I have 2million rows of data in CSV. I was able to load it in Power Pivot for Excel but want some better ideas of splitting the dataset in different tabs into Excel. If Excel could've handled the data more than 1M rows, this would've been a lot easier.

    I want to use the data in one of the columns and put those filtered values in different tabs.

    For example, the Region Column has only four text data (South, North, East and West) and I want the South tab has the data that are filtered only with South Region.

    Is there any easier way to manipulate dataset and put it in Excel?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Helping with Splitting Large Dataset into Tabs

    Post a sample csv with a couple of dozen recs.



    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ 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. Replies: 3
    Last Post: 10-20-2017, 12:40 AM
  2. Splitting dataset in to new sheets by month
    By igwtdav in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-25-2016, 12:01 PM
  3. Large dataset sorting help
    By kjibbs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2014, 12:35 PM
  4. Replies: 3
    Last Post: 01-23-2014, 10:13 AM
  5. [SOLVED] Graphing a large dataset
    By CTM2012 in forum Excel General
    Replies: 6
    Last Post: 06-18-2012, 03:48 PM
  6. Helping finding different Tabs
    By skate1991 in forum Excel General
    Replies: 2
    Last Post: 06-12-2012, 06:14 AM
  7. Need Helping With Addition Across Tabs
    By cleary71 in forum Excel General
    Replies: 2
    Last Post: 10-15-2008, 07:22 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