Results 1 to 2 of 2

Thread: Breaking up cell's content into separate rows

  1. #1

    Breaking up cell's content into separate rows



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I have a workbook with a bunch of data that I need to break up into separate cells in order to be able to sort. currently a single cell may contain 1, 2, 3, line items, I want to be ale to put them in single rows/cells. I already tried but it's not working properly, see attached file.
    Attached Files Attached Files

  2. #2
    Conjurer snb's Avatar
    Join Date
    May 2013
    Posts
    374
    Articles
    0
    Excel Version
    2020
    Code:
    Sub M_snb()
         sn = Cells(1).CurrentRegion
    
         For j = 1 To UBound(sn, 2)
            sp = Split(Join(Application.Transpose(Application.Index(sn, 0, j)), vbLf), vbLf)
            Cells(1, j).Resize(UBound(sp) + 1) = Application.Transpose(sp)
         Next
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •