+ Reply to Thread
Results 1 to 13 of 13

Combine saveral column into 1 column

  1. 12-17-2023, 03:15 AM #1
    wiewie002
    wiewie002 is offline
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Combine saveral column into 1 column

    Dear Friends,
    Need you support to advise formula.
    I do create data below

    Component number Where use
    3967 30010, 20300
    3970 20300
    1222 20010, 20020, 20030, 20040

    Currently I used TEXTJOIN manually. so need help to advise what formula excel I can use to combine the data.
    Sample as attached file.

    Thank you in advance

    Wie Wie
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-17-2023, 03:18 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,981

    Re: Combine saveral column into 1 column

    Which version of Excel are you using? TEXTJOIN is not in 2013! Please update your forum profile.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 12-17-2023, 03:23 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,981

    Re: Combine saveral column into 1 column

    If you have Excel 365, you can use the following. Remove ALL expected results, then this in F4:

    =LET(u,UNIQUE(A4:A16),SORT(HSTACK(u,BYROW(u,LAMBDA(r,TEXTJOIN(", ",,UNIQUE(FILTER(C4:C16,A4:A16=r)))))),1,1))
    Attached Files Attached Files
    Last edited by AliGW; 12-17-2023 at 03:27 AM. Reason: Workbook added.
    Reply With QuoteRegister To Reply
  4. 12-17-2023, 03:25 AM #4
    wiewie002
    wiewie002 is offline
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Re: Combine saveral column into 1 column

    Hi Ali,
    I used office 365, still checking how to update profile
    Thanks
    Reply With QuoteRegister To Reply
  5. 12-17-2023, 03:26 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,981

    Re: Combine saveral column into 1 column

    OK - solution in post #3.
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  6. 12-17-2023, 03:32 AM #6
    wiewie002
    wiewie002 is offline
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Re: Combine saveral column into 1 column

    Thanks, I have update.
    Reply With QuoteRegister To Reply
  7. 12-17-2023, 03:33 AM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,981

    Re: Combine saveral column into 1 column

    Glad to have helped.

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
    Reply With QuoteRegister To Reply
  8. 12-17-2023, 03:33 AM #8
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,435

    Re: Combine saveral column into 1 column

    Please try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 12-17-2023, 03:43 AM #9
    wiewie002
    wiewie002 is offline
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Re: Combine saveral column into 1 column

    Thank you for your support
    Reply With QuoteRegister To Reply
  10. 12-17-2023, 03:45 AM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,981

    Re: Combine saveral column into 1 column

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
  11. 12-17-2023, 03:48 AM #11
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,435

    Re: Combine saveral column into 1 column

    Thanks for the rep . Glad to have helped.
    Reply With QuoteRegister To Reply
  12. 12-17-2023, 05:13 AM #12
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,294

    Re: Combine saveral column into 1 column

    Power Query
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  13. 12-17-2023, 08:17 AM #13
    HSV
    HSV is offline
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    818

    Re: Combine saveral column into 1 column

    Different sequence
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Kind regards, Harry.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to combine rows with duplicate value in one column, but list data in second column
    By dweingar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2019, 12:53 PM
  2. [SOLVED] How to combine multiple column data to single column using formula
    By krishnakuma6 in forum Excel General
    Replies: 6
    Last Post: 06-05-2018, 06:13 AM
  3. Combine Text Fields within Column for Duplicate Entries in Adjacent Column
    By ANKRULL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2013, 12:58 AM
  4. Combine multiple columns into one column with header and date in another column
    By JJadams in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2012, 05:30 PM
  5. Combine rows by adding amounts found in column d for duplicate names in Column a
    By bnasty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2012, 09:29 PM
  6. How Do I Combine Different Cell Data in Column B with one single Part Number in Column A
    By leadfeet in forum Excel General
    Replies: 7
    Last Post: 10-23-2012, 02:29 PM
  7. [SOLVED] How do you combine a stacked column and single column graph?
    By Charlotte C in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2005, 09:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1