+ Reply to Thread
Results 1 to 5 of 5

Moving Repeating Data from Rows to Columns (Not Transpose)

  1. #1
    Registered User
    Join Date
    02-03-2023
    Location
    Texas, USA
    MS-Off Ver
    Office 365
    Posts
    3

    Question Moving Repeating Data from Rows to Columns (Not Transpose)

    Someone asked almost an identical question to what I have, but with one minor change and I can't seem to figure out how to accommodate that change.

    Well, I tried to post the link but I can't since I'm a new user. The post has the exact same title as mine and I have the exact same question that the user in post #6 had.

    Basically, I need a formula to move 4 repeating data sets into separate columns. Someone provided the answer/formula below, but I do not have the 5th empty row as they had. And I don't know how to 'fix' the formula to accommodate for the difference.

    Assuming:

    1) Data is in column A starting at A1 (no header)
    2) Every 5th cell is blank
    3) D1:G1 are the headers for you new table (First, Last, Number, Type)

    Put this formula in D2, copy to the right and down until you start seeing zeros:

    =INDEX($A:$A,ROW($A1)*5-4+COLUMN(A$1)-1)

    My data:

    (Jurisdiction)
    (Search Fee)
    (County Fee)
    (Date)
    (Jurisdiction)
    (Search Fee)
    (County Fee)
    (Date)
    (Jurisdiction)
    (Search Fee)
    (County Fee)
    (Date)
    (Jurisdiction)
    (Search Fee)
    (County Fee)
    (Date)

    What I need:

    (Jurisdiction) (Search Fee) (County Fee) (Date)
    (Jurisdiction) (Search Fee) (County Fee) (Date)
    (Jurisdiction) (Search Fee) (County Fee) (Date)

    Thank you!
    Attached Files Attached Files
    Last edited by emtaylor517; 02-03-2023 at 05:12 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Moving Repeating Data from Rows to Columns (Not Transpose)

    You might not be able to post a link (until you have made 10 posts), but you can attach a sample Excel workbook - the yellow banner at the top of the screen describes how to.

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: Moving Repeating Data from Rows to Columns (Not Transpose)

    Try

    in B1

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Data starting in A1

    Copy across and down
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  4. #4
    Registered User
    Join Date
    02-03-2023
    Location
    Texas, USA
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Moving Repeating Data from Rows to Columns (Not Transpose)

    Quote Originally Posted by Pete_UK View Post
    You might not be able to post a link (until you have made 10 posts), but you can attach a sample Excel workbook - the yellow banner at the top of the screen describes how to.

    Hope this helps.

    Pete
    Done, thank you.

  5. #5
    Registered User
    Join Date
    02-03-2023
    Location
    Texas, USA
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Moving Repeating Data from Rows to Columns (Not Transpose)

    Quote Originally Posted by JohnTopley View Post
    Try

    in B1

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Data starting in A1

    Copy across and down
    Worked perfectly, thank you!!

+ 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. Moving data from a column to rows (transpose did not work)
    By Jones63 in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 11-22-2022, 09:54 AM
  2. [SOLVED] Moving Repeating Data from Rows to Columns (Not Transpose)
    By mifac in forum Excel General
    Replies: 6
    Last Post: 07-30-2021, 04:08 PM
  3. [SOLVED] Moving Repeating Data from Rows to Columns (Not Transpose)
    By sepmir1 in forum Excel General
    Replies: 16
    Last Post: 10-15-2019, 08:23 PM
  4. Transpose column data to individual rows, while repeating certain cells per row
    By NightmanCometh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2017, 01:40 AM
  5. [SOLVED] Need help on macro to transpose rows to columns while repeating certain column N times
    By cmleong in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2016, 11:07 PM
  6. [SOLVED] Transpose Columns to Rows While Repeating Data in First Column to Each Row
    By leoxanigm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-29-2015, 06:54 AM
  7. Replies: 7
    Last Post: 02-05-2015, 03:20 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