+ Reply to Thread
Results 1 to 3 of 3

Single Cell of multiple Items need as multiple rows

  1. #1
    Registered User
    Join Date
    07-06-2022
    Location
    Fort Worth, Texas
    MS-Off Ver
    365
    Posts
    1

    Post Single Cell of multiple Items need as multiple rows

    My Excel skills are not advanced and I don't know if what I need already exists in Excel but I am not finding it.

    I have Excel Sheets with two columns; multiple rows. These are SKU Names
    Values Are Alpha Numeric values (Text)
    Column A Multiple values with "Comma Space" Delimiter
    Column B Single value

    Need Column A values to be individual Rows with the value in Column Be duplicated. I am attaching sample of what I have and how I need it to look.

    WHAT MY LIST HAS
    Similar Products Archived SKU
    10864.1, 14992.4, 551TI114 15641.1

    WHAT I NEED
    Similar Products Archived SKU
    10864.1 15641.1
    14992.4 15641.1
    551TI114 15641.1
    Attached Files Attached Files

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,117

    Re: Single Cell of multiple Items need as multiple rows

    This can be achieved in one step with Power Query

    Please Login or Register  to view this content.
    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.
    Attached Files Attached Files
    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

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,776

    Re: Single Cell of multiple Items need as multiple rows

    vba
    Please Login or Register  to view this content.

+ 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. [SOLVED] Breakout multiple items from a single cell into their own row
    By PeteABC123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-18-2020, 10:17 AM
  2. Replies: 9
    Last Post: 03-09-2018, 03:11 PM
  3. Macro to convert lists in a row to multiple rows with single items
    By gilbro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2016, 10:55 AM
  4. Multiple [BRACKETED TERMS] on multiple related rows to single comma seperated cell
    By fau5tu5 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-08-2015, 05:31 AM
  5. Replies: 14
    Last Post: 08-20-2014, 05:46 AM
  6. Replies: 5
    Last Post: 05-25-2013, 07:12 AM
  7. Combining single rows into multiple lined items
    By bread in forum Excel General
    Replies: 1
    Last Post: 08-31-2009, 12:27 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