+ Reply to Thread
Results 1 to 2 of 2

Need to Combine ALL data into one Tab

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Question Need to Combine ALL data into one Tab

    I have one spreadsheet with 12 tabs. Each tab has the exact same "type" of information but from different months of the year. I want to import or copy ALL of that data into ONE NEW tab that I call "Combined" so I can better analyze it.

    I used column A through F in each of the 12 tabs to collect the initial data. The number of rows in each column varies depending on the amount of data collected that month. (Please assume that I have data in 5000 rows of each column of all 12 tabs) I am attaching a sample of the data that has been deidentified.


    Thank you in advance!!!
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,573

    Re: Need to Combine ALL data into one Tab

    Here's a nice free and reliable addin that will do the trick easily

+ 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. Combine Data in Multiple Columns to One Column Based on Data in Rows
    By exceldivx in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-09-2014, 07:35 AM
  2. Replies: 8
    Last Post: 11-25-2013, 10:26 PM
  3. Combine data from 4 workbooks and then export filtered data to individual files?
    By womanket in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2013, 12:20 PM
  4. Combine Duplicate Rows and Combine Data in Rows
    By cherylmcgk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2013, 12:04 PM
  5. Using Macros to combine multiple lines of data when Address column data is the same.
    By chrispy123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2012, 01:25 AM

Tags for this Thread

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