+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : how to combine multiple rows in a merge cell?

  1. #1
    Registered User
    Join Date
    09-13-2011
    Location
    marikina, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post how to combine multiple rows in a merge cell?

    i just want to combine my rows into a one merge cell..

    .........A..............B
    1.....4 cups of flour
    2.....3 tsp of salt
    3.....5 kilo pork

    and i need to make it like these

    ......C.........D
    5..4 cups of flour
    ....3 tsp of salt
    ....5 kilo pork
    6
    7

    NOTE: there is a function (PRODUCT) in the ingredients so i can't just retype it

    i'am sorry, i'am a noob in excel and i don't know if these is even possible... hope someone can help me
    Last edited by jblures; 09-13-2011 at 03:23 PM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: how to combine multiple rows in a merge cell?

    Please see the attached which uses an Example lifter from Excel Help for ...

    Combine two or more columns by using a function
    Attached Files Attached Files
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1