Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Help

  • 26-01-2011 03:19PM
    #1
    Budgieoc18
    Registered Users, Registered Users 2 Posts: 55 ✭✭


    Hi.
    Im doing up spreadsheets of products (10000's) for an online shopping channel and i have hit a problem.

    I have 3 merged cells together under Column A, so under column B and C there are three cells per one cell in A. Each of the 3 Cells have a different Product in them eg:

    _____A_______B_______C
    1 AUDI A5____2367____1234
    2___________3827____3467
    3___________3647____9866

    Ok what i need to do is insert two columns after column B and column C to have all the prdoucts in the one row. I need to do this for the upload.


    So what I need to do is eg:

    ____A______B_____C____D____E____F____G
    1 AUDI A5___2367__3827_3647_1234_3467_9866
    2
    3

    I hope i have explained it properly...if not let me know..and i hope someone can help..thank you in advance.

    ATTACHED IS A BIT OF THE FILE IF YOU WANT TO HAVE A LOOK.


Comments

  • #2
    woolymammoth
    Registered Users, Registered Users 2 Posts: 1,772 ✭✭✭woolymammoth


    either i'm blind, or you forgot the attachment! either is extremely likely at the moment


  • #3
    Budgieoc18
    Registered Users, Registered Users 2 Posts: 55 ✭✭Budgieoc18


    Sorry---File Attached there now. Thank You


  • #4
    woolymammoth
    Registered Users, Registered Users 2 Posts: 1,772 ✭✭✭woolymammoth


    i'm not sure i understand the problem.. you want to insert columns? just right-click on C, insert. repeat as necessary.. or am i misreading this entirely?


  • #5
    Budgieoc18
    Registered Users, Registered Users 2 Posts: 55 ✭✭Budgieoc18


    Im new at this so find it hard to explain my problem on this. Sorry.
    Ok attached is another spreadsheet sheet one has what i have and sheet two has what i need.

    In sheet "have" its easy for me to insert a new column after column E and then copy and Paste E3 into new column F2.

    Same has to be done with E7 and D7 and so on. I want just one row per product in coumn A where as now i have 2 or 3 rows per one product.

    I hope this makes a bit more sense. Reason I dont want to do them one by one as explained is because i have more than 10,000 so is there a simple formula etc for doing this.

    Thank You.


  • #6
    homer911
    Registered Users, Registered Users 2 Posts: 5,067 ✭✭✭homer911


    Try the attached - I've filtered out the non blank column A - you could reverse the filter and delete the blank rows to get exactly as you need - I'm assuming two rows per Model/Engine/Year - you would need to change this if its not the case

    Before you delete the unwanted rows, dont forget to paste/value the new colums


  • Advertisement
Advertisement