+ Reply to Thread
Results 1 to 3 of 3

Complex table transformation - Insert rows between 2000 rows and move column data to row d

  1. #1
    Registered User
    Join Date
    06-25-2019
    Location
    US
    MS-Off Ver
    MS 17
    Posts
    1

    Complex table transformation - Insert rows between 2000 rows and move column data to row d

    I have a spreadsheet with 60 columns and 2000 rows worth of data. It is formatted like the table on the left in the screenshot. I need to get it into the format on the right.


    So basically, I want to insert n number of rows after each row with data and then move data in the columns to the newly created rows.

    2019-06-25_14-00-09.png

  2. #2
    Registered User
    Join Date
    06-28-2017
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    54

    Re: Complex table transformation - Insert rows between 2000 rows and move column data to r

    If it goes in order in groups of three its very simple. You just type May, June July in the first three columns, then set the next three cells equal to the corresponding cells and drag all the way down. So like in your example you would start in B3 and type "May", B4 June, B5 July... and then in B6 you put the formula = B3, then in B7 = b4, then in b8 = b5, then just simply highlight b6-b8 and drag the formula down.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Complex table transformation - Insert rows between 2000 rows and move column data to r

    Hello justayellowbusman2 and Welcome to Excel Forum
    In addition to Adamsc21's proposal type the value 1023 in cells A3:A5 then place =SUM(A3,1) in cell A6 and double click the fill handle.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Transpose rows to column and insert new rows to fill in data
    By Apple Ling in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2019, 04:02 AM
  2. To automate the transformation of a data column to a two dimensional table
    By geniusufo007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2017, 11:54 PM
  3. [SOLVED] To move Data rows to columns against one cell so can write separate SQL insert statments
    By hadster016 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2014, 09:52 AM
  4. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  5. [SOLVED] Deleting rows by column data with various criteria (complex)
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-28-2013, 07:58 PM
  6. Insert rows, transpose data from column in to rows, in steps
    By mchevalier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2012, 08:14 PM
  7. Need help!!! Have to move rows to columns but in a complex way.
    By cholme in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2012, 01:23 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