Results 1 to 7 of 7

Thread: Conversion Of Data In Column To One Cell

  1. #1
    Junior Member
    Join Date
    Aug 2013
    Posts
    4
    Rep Power
    0

    Conversion Of Data In Column To One Cell

    Hi, I would like to convert on xls, generate from SAP to some more useful form. But, I failed on converting vertical cells into one cell. I was searching on internet whole day, but without any success. I would prefer Formulas solution. I also find similar problem here on forum solved by formulas, but I was not able to use it for my scenario.
    There is one more thing that the array which I want to merge, is different each time.

    Description: This is list of electrical components generated from SAP its called Bill Of Material. Some other description is in attached document. Some columns are hidden, they are not relevant for conversion.

    Thanks for help,
    Vojta
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    macak, can be done, but I would recommend VBA for this rather than formula.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Aug 2013
    Posts
    4
    Rep Power
    0
    Ok, I would prefer Formulas because Im totally new to VBA, well in some advanced work with Excel too.
    What I created so far with formulas is actually "retyped" cycle, so I guess the solution with VBA could be easy if created for only this doc.

  4. #4
    Junior Member
    Join Date
    Aug 2013
    Posts
    4
    Rep Power
    0
    So, I managed to made it finally. It was not actually so hard at the end I just needed to learn about Indiricet formula. If someone would be interested I can attach XLS.

  5. #5
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Yes, would be great if you could attach the solution here
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  6. #6
    Junior Member
    Join Date
    Aug 2013
    Posts
    4
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    Yes, would be great if you could attach the solution here
    Ok, its simplified version to see the core of it.ColumToCell-ExFox.xlsx
    So, I managed to covert columns to one cell, but with help of some things, like I know number of there vert. cells when Im at ProductNumber, its already generated. Therefore I do not have some function which would do that, and I guess it could be complicated. Hopefully it could be useful at least to someone.

  7. #7
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Thanks for sharing macak
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 34
    Last Post: 03-13-2015, 02:26 PM
  2. Replies: 4
    Last Post: 06-01-2013, 01:08 PM
  3. Replies: 2
    Last Post: 05-30-2013, 07:28 PM
  4. Highlight Active Cell’s Row and Column
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  5. Lookup From Cell Range By Matching Row and Column
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 03-07-2013, 02:02 PM

Posting Permissions

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