+ Reply to Thread
Results 1 to 6 of 6

Convert Columns Data to Rows Data

  1. 11-30-2022, 06:48 PM #1
    elbarauljr
    elbarauljr is offline
    Registered User
    Join Date
    12-29-2016
    Location
    United State
    MS-Off Ver
    O365
    Posts
    36

    Convert Columns Data to Rows Data

    Hello all,

    I have a spreadsheet (attached file) were I manually converted the green Rows 1 thru 6 into the yellow Rows 2 thru 19. Is there possible formula or code to automatically create all Rows 2 thru 24 (Columns A thru J) into Rows (Columns L thru V) ?

    Here are some steps for the manual input to convert the green Rows into the yellow Rows:

    Note: Every Row in columns A thru J is a unique combination of columns A and B

    1. Transposed not empty amounts in green Rows 2 thru 6 into Column V, then

    2. Combined green Column C values with Row 1 values were amount is not empty and copied to Column P, then

    3. Repeated green Column B data into Column S for the corresponding Row

    The workbook don't have specific name, just work based on the open and active Workbook/Spreadsheet.


    Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-30-2022, 08:14 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,864

    Re: Convert Columns Data to Rows Data

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 11-30-2022, 08:32 PM #3
    elbarauljr
    elbarauljr is offline
    Registered User
    Join Date
    12-29-2016
    Location
    United State
    MS-Off Ver
    O365
    Posts
    36

    Re: Convert Columns Data to Rows Data

    Sorry, I posted in the other site, but my computer did not allowed to attached the file as additional software was required.
    Last edited by elbarauljr; 12-15-2022 at 08:56 PM.
    Reply With QuoteRegister To Reply
  4. 11-30-2022, 11:25 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,864

    Re: Convert Columns Data to Rows Data

    crossposting is allowed. You need to post the link to the other site. Read the full post #2 and comply
    Reply With QuoteRegister To Reply
  5. 12-01-2022, 09:06 AM #5
    elbarauljr
    elbarauljr is offline
    Registered User
    Join Date
    12-29-2016
    Location
    United State
    MS-Off Ver
    O365
    Posts
    36

    Re: Convert Columns Data to Rows Data

    For the solution, please refer to the following link: https://www.mrexcel.com/board/thread.../#post-5984062
    Reply With QuoteRegister To Reply
  6. 12-01-2022, 09:08 AM #6
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Convert Columns Data to Rows Data

    On Mr Excel your profile shows O365. Please update your profile HERE as well.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert 6 columns of data to single rows of data
    By CHillFL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-14-2015, 04:48 PM
  2. Excel 2007 : Convert data from columns to rows
    By thandanit in forum Excel General
    Replies: 3
    Last Post: 03-27-2011, 10:55 PM
  3. Excel 2007 : Convert data from columns to rows
    By thandanit in forum Excel General
    Replies: 1
    Last Post: 03-17-2011, 03:41 AM
  4. Convert a set of data from rows to columns
    By naferterri in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2010, 08:33 PM
  5. Convert data from columns to rows
    By ClikClak in forum Excel General
    Replies: 5
    Last Post: 07-19-2010, 12:26 PM
  6. How can I transpose or convert rows of data into columns of data:
    By dcoates in forum Excel General
    Replies: 3
    Last Post: 02-12-2009, 02:54 PM
  7. [SOLVED] Convert data from rows to columns
    By boksic in forum Excel General
    Replies: 4
    Last Post: 07-04-2005, 07:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1