Results 1 to 2 of 2

Thread: Merging columns

  1. #1

    Merging columns



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

    Hello guys,

    I really need your help regarding a task in my work, which I cannot figure out how to do. I am content administrator of the website and I have to take care for publishing around 8000 thousand prices, which I obviously need to do by bulk upload. Till now, I used to do it like this: Pricing provided me with the price list in their format, and in order to have it in the appropriate format for the site, I used a macro to take all the values and place them in my file for upload.
    But now the pricing department changed the format of their file and I need to wait at least to weeks to have the new file for me with the new macro.
    During this time I need to find a way to do it by myself.
    The problem is the following:
    Previously, every item was offered with a tariff with two prices - cash price and leasing price. The two prices were in one column, one cell under another per each item.
    Now, the cash price and leasing price are in two columns. As it seems, I need to merge the two columns but to have each cell from the second column to be placed under the respective sell from the first column (the one with which are on one row).
    Is there an easy way to do this and how?
    Example:
    item 1 cash 99.99
    item 1 lease 9.99
    item 2 cash 89.99
    item 2 lease 8.99
    item 3 cash 79.99
    item 3 lease 7.99

    Item N Cash price Lease Price
    Item 1 99.99 9.99
    Item 2 89.99 8.99
    Item 3 79.99 7.99


    Basically, the task is to convert somehow the second table into the first one..

    Thank you in advance!
    Kamen

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    it can be done by PIVOT TABLE.
    Attached Files Attached Files

Posting Permissions

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