Forum Discussion

dcd2020's avatar
dcd2020
Copper Contributor
Sep 16, 2020

Combining Cells in columns

Need help in combining three columns, each with three cells with different text - that share the same part number in a different column.

 

Want to combine (in this example), the three cells per column in its own cell; the info from the three cells combined in one cell in a vertical fashion.

 

Please see the before & after screenshots of example

before combining:

 

after combining:

 

Thanks!

 

 

excel

8 Replies

  • mathetes's avatar
    mathetes
    Silver Contributor
    Sep 16, 2020

    dcd2020 

     

    Why? So it looks prettier? That's not really a sufficient reason.

     

    You'd be messing up your ability to take advantage of Excel's ability to work with a data table to produce summary reports, Pivot Tables, whatever...

     

    So I'd advise against it.

     

    If you insist on doing it, Format....Cells....Alignment and select "Merge Cells" and then deal with where you want the text to appear.

     

    But as noted, it's not generally a good practice.

    • dcd2020's avatar
      dcd2020
      Copper Contributor
      Sep 16, 2020

      mathetes 


      Thanks, i'm sure I didn't explain good enough;

      We periodically receive customer Boms (bill of materials) with alternate part numbers on each row (for the same part number & reference designator); I however, need them in ONE cell; not in merged cells.


      Again, what I'm doing isn't merging at all, its combining data from three cells in a column, that each refer to a same part number, and then placing them into one cell in the same column.


      I need to place multiple info, for example - part numbers, vendor names, customer part numbers, etc, into their own separate cells which are NOT merged; on one row for each unique part number & its Reference Designator group.

       

      The screenshots i provided did not have any merged cells.

       

      Hope this helps
      thanks again

      • mathetes's avatar
        mathetes
        Silver Contributor
        Sep 17, 2020

        dcd2020 

        You wrote: The screenshots i provided did not have any merged cells. So maybe this is a good illustration of why an image conveys confusing information compared with the upload of the actual spreadsheet. I trust you can see why they look to be merged. (It is possible to merge cells vertically as well as horizontally, and that is definitely how these appear.)

         

         

        All of that having been said, it still isn't clear then what you are wanting to do. Maybe more, what's the outcome you're expecting? What will you be doing WITH this data? Why is it that you're putting such emphasis on combining those three rows into one (OK, not "merging" per se, but "combining data from three cells in a column, that each refer to a same part number, and then placing them into one cell in the same column"?)  WHY? What does that get you that leaving that redundant data on each row, where it is differentiated from the other very similar parts by the other codes, doesn't get you?

         

        From the perspective of a good database, I don't understand the reason for doing it, beyond a certain visual clarity. And as I noted at the start, it would interfere with other data retrieval functions.

Resources