+ Reply to Thread
Results 1 to 2 of 2

CONCATENATE cells if number in first column is the same

  1. #1
    Registered User
    Join Date
    10-26-2020
    Location
    Voorhout
    MS-Off Ver
    365
    Posts
    18

    CONCATENATE cells if number in first column is the same

    Dear All,
    hope you have a simple solution.
    I have a few large files containing 2 columns.
    Both columns only contain numbers.
    If the number in column A2 is the same as A3, i need to concatenate the numbers in B2 and B3 devided by a comma.
    Sometimes A2 is the same as A3, A4 etc up to A1000 (and more)

    So example

    7141 - 1000
    7141 - 1001
    7141 - 1002
    7025 - 1003

    I need this outcome : 7141 - 1000,1001,1002

    Maybe this is very simple but i can't find a way.

    Thanks in advance for looking at it.

    Best regards, Ed
    Last edited by Ed1971; 04-13-2023 at 11:23 AM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: CONCATENATE cells if number in first column is the same

    with Power Query

    A B A List
    7141
    1000
    7141
    1000,1001,1002
    7141
    1001
    7025
    1003
    7141
    1002
    7025
    1003


    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Concatenate Text in Column B Split in Multiple Rows for Each Number in Column A
    By zaska in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2020, 03:51 AM
  2. concatenate if the column same number
    By excelislive in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2016, 10:16 AM
  3. [SOLVED] UDF for concatenate predefined number of cells
    By jessko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-12-2016, 02:08 PM
  4. [SOLVED] Vlookup in column index number 2 with concatenate
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2015, 06:02 AM
  5. [SOLVED] Concatenate variable number of lines within a column
    By ferndiazabarca in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-03-2015, 02:29 AM
  6. Compare cells in column 1 and concatenate values in column 2
    By sharmaremuk in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-20-2011, 09:04 PM
  7. Can I use CONCATENATE with a varying number of cells?
    By djbosworth in forum Excel General
    Replies: 1
    Last Post: 09-22-2009, 07:57 AM

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