Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Sep 2011
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy Red face copy rows on cell based value and condtionaly paste it to other column

    Hi
    this is very dynamic requirement.
    I have attached image as well sample sheet for what i need.

    In brief:
    I want to transfer(cut or moving) the cells to respective column but on same row from where is has been cut.

    For example: (where , (comma) means different column


    Account No.1
    item33,quantity,amount,
    item2,quantity,amount,
    item48,quantity,amount,

    Account No.2
    item9,quantity,amount,

    Account No.3
    item19,quantity,amount,
    item2,quantity,amount,
    item6,quantity,amount,
    item75,quantity,amount,
    item52,quantity,amount,

    Now i want put it like this

    Account No.1 item33,quantity,amount,
    Account No.1 item2,quantity,amount,
    Account No.1 item48,quantity,amount,

    Account No.2 item9,quantity,amount,

    Account No.3 item19,quantity,amount,
    Account No.3 item2,quantity,amount,
    Account No.3 item6,quantity,amount,
    Account No.3 item75,quantity,amount,
    Account No.3 item52,quantity,amount,

    I have also attached image and sample excel file.
    [img=http://s4.postimage.org/3208mebvo/data_convert.jpg]
    Excel file is attached below.
    Attached Thumbnails Attached Thumbnails Red face copy rows on cell based value and condtionaly paste it to other column-data-convert.jpg  
    Attached Files Attached Files

  • #2
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Sounds like you might want to look in to using a pivot table to flatten your data.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #3
    New to the CF scene
    Join Date
    Sep 2011
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    cant use pivot table. as two different fields are in same column.


  •  

    Tags for this Thread

    Posting Permissions

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