1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • How to merge cell value from cells with the same ID

    From AA Arens@21:1/5 to All on Sun Mar 28 19:49:57 2021
    I do have two columns - one with ID number and another with name.

    How, in a new column, to merge contents of cells with the names that shares the same ID number. The contents in the cell must be listed in separate lines within the cell (CONCAT but with return).

    Bart

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From AA Arens@21:1/5 to AA Arens on Tue Mar 30 03:45:03 2021
    On Monday, 29 March 2021 at 09:50:01 UTC+7, AA Arens wrote:
    I do have two columns - one with ID number and another with name.

    How, in a new column, to merge contents of cells with the names that shares the same ID number. The contents in the cell must be listed in separate lines within the cell (CONCAT but with return).

    Bart
    Already sorted it out. Thanks.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)