+ Reply to Thread
Results 1 to 4 of 4

Columns to Rows

  1. #1
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    154

    Columns to Rows

    Okay, so I'm not sure if this is something that can be done with a formula or not. On the attached sheet, I have EE ID's in column A and programs in columns B through G. An EE can have up to 6 programs. I'm trying to figure out how to reduce the columns, so that I have all the data in two columns (on the sheet, the example is K and L). So, if an EE ID has more than 1 program, the would need a new row with the EE ID and the other program. An EE ID could potentially have six programs.

    This is what I'm trying to get:
    EE ID Program
    200120 Microsoft
    200121 Dell
    200121 Python
    200121 Microsoft
    200122 Playground
    200122 Dell
    200122 Microsoft
    200122 Python
    200122 Excel
    200122 JAARI
    200123 Python
    200124 Dell
    200124 Microsoft
    200124 Python
    200124 Excel
    200124 JAARI
    200125 Excel
    200126 Excel
    200126 Python
    200126 Microsoft
    200126 JAARI
    200126 SIMMS
    200127 Microsoft
    200127 Python




    The data is formatted like this though:
    EE ID Program 1 Program 2 Program 3 Program 4 Program 5 Program 6
    200120 Microsoft
    200121 Dell Python Microsoft
    200122 Playground Dell Microsoft Python Excel JAARI
    200123 Python
    200124 Dell Microsoft Python Excel JAARI
    200125 Excel
    200126 Excel Python Microsoft JAARI SIMMS
    200127 Microsoft Python
    Attached Files Attached Files

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,435

    Re: Columns to Rows

    Here is an Excel 2021 solution:

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

  3. #3
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    154

    Re: Columns to Rows

    What in God's name.... Wow, I'm impressed. That worked. Thank you!

  4. #4
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,435

    Re: Columns to Rows

    You are Welcome!

    Thanks for your feedback, Glad to have helped. .

    If you haven't already, please consider adding reputation to all helpers you think they deserve.
    In that case please click * Add Reputation left below their answers.

+ 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. Replies: 1
    Last Post: 05-30-2015, 03:12 PM
  2. [SOLVED] Formula to transpose rows to new columns and columns to new rows in Excel
    By bjnockle in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-26-2014, 06:28 PM
  3. Merge Duplicate Rows unique values into single rows for an infinite amount of columns/rows
    By aimeecrystalaid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2013, 08:43 PM
  4. Combining multiple rows from 2 columns into sorted columns depending on 1st columns value
    By Dexamphetamine in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-11-2013, 10:00 AM
  5. Replies: 15
    Last Post: 12-06-2012, 01:07 PM
  6. [SOLVED] Swapping rows for columns and columns for rows in a large database
    By Bloomingdales in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2012, 06:06 PM
  7. Replies: 0
    Last Post: 11-28-2007, 06:46 AM

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