+ Reply to Thread
Results 1 to 3 of 3

Rearranging data to new table sizes?

  1. #1
    Registered User
    Join Date
    08-24-2015
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    2

    Rearranging data to new table sizes?

    Hi

    So I'm dealing with data being exported from incredibly old and outdated software. The data that I need was exported into a single row, 2880 columns long. -_-

    I need to rearrange it into a table that is 12 columns, with 240 rows. The first twelve cells of my single row of data would be the first row of the new table, the second twelve columns would be the second row, etc and so forth. Is there a way to do this without copy/pasting 12 cells at a time?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,076

    Re: Rearranging data to new table sizes?

    Try this

    Please Login or Register  to view this content.
    Input in Sheet1
    Output in Sheet2
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    08-24-2015
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    2

    Re: Rearranging data to new table sizes?

    It worked! Thanks!

+ 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. rearranging data from one table into another table
    By kvuytfan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2014, 08:57 AM
  2. Rearranging data in a table without calculating anything
    By DaynaBarnes in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-08-2014, 09:05 AM
  3. Rearranging a data table into a different layout
    By pauldaddyadams in forum Excel General
    Replies: 10
    Last Post: 10-28-2013, 03:37 PM
  4. Formatting Data as Table in Macros (variable data sizes)
    By jwood1976 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2011, 06:40 AM
  5. Rearranging data and putting into a league style table
    By Paulley in forum Excel General
    Replies: 10
    Last Post: 06-06-2009, 10:49 AM
  6. Rearranging data to better perform in a pivot table
    By rjc008 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-27-2008, 06:29 PM
  7. Rearranging Data Set by a Table
    By mtrant in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2008, 03:08 PM

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