Results 1 to 2 of 2

Split one cell with multiple data

Threaded View

  1. 06-19-2014, 01:17 PM #1
    harry0812
    harry0812 is offline
    Registered User
    Join Date
    06-19-2014
    Location
    dallas
    MS-Off Ver
    2010
    Posts
    1

    Split one cell with multiple data

    Hi Everyone,

    Please help me in the below request to split a cell with multiple data into individual rows.
    I am attaching my excel sheet with this post in case you want to see the data.

    Basically, I have the format as below


    Row1 Data1
    Data2
    Row2 Data3
    Data4

    I want to split the 2 cells in the below manner


    Row1 Data1
    Row1 Data2
    Row2 Data3
    Row2 Data4


    Please help me in the above split issue. Thanks a lot in advance for your help and support.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Macro to split cell data across multiple cells based on format-
    By Biased Historian in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-30-2013, 12:57 PM
  2. [SOLVED] How do you split a cell that contains multiple data to the cells beside it?
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2013, 08:37 AM
  3. [SOLVED] Split a cell of data into multiple rows
    By otterandrews in forum Excel General
    Replies: 4
    Last Post: 03-24-2013, 11:59 PM
  4. Row split in to multiple rows based on cell data
    By bosuck in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2011, 05:30 PM
  5. Want to split the data in single cell to multiple column
    By pradeepdeepu_001 in forum Excel General
    Replies: 4
    Last Post: 02-02-2010, 09:11 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