+ Reply to Thread
Results 1 to 3 of 3

Concatenate Lines 'a' and 'b' for each key.

  1. #1
    Registered User
    Join Date
    03-21-2020
    Location
    brazil
    MS-Off Ver
    2019
    Posts
    7

    Concatenate Lines 'a' and 'b' for each key.

    My spreadsheet has hundreds of lines. Here is a sample:

    deletar.png

    I would like to merge all the elements of lines 'a' and 'b' for each key index "3A~" into a single line.
    The order of the elements in this new line would be: first all the elements of 'a' line (preserving original order o 'a'). THEN, all the elements of 'b' line (preserving original order of 'b').

    It's the same as concatenating the 'b' line into the end of 'a' line, deleting the former 'b' line and renaming "3A~a" to "3A~".

    expected result:
    deletar2.png

    Any help will be much appreciated!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,855

    Re: Concatenate Lines 'a' and 'b' for each key.

    Please read the yellow banner at the top of this page on how to attach a file. We cannot manipulate data in a picture.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-29-2020
    Location
    New Delhi
    MS-Off Ver
    2008
    Posts
    3

    Re: Concatenate Lines 'a' and 'b' for each key.

    Please send your spreadsheet

+ 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. concatenate a large number of datas (600 lines and 300k characters)
    By Ventvent in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2019, 07:38 PM
  2. [SOLVED] Skip Lines in Concatenate
    By GoGoeGo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2016, 02:56 PM
  3. [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
  4. [SOLVED] Concatenate cells by lines
    By lavinius in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-07-2013, 11:03 AM
  5. [SOLVED] Concatenate variable number of lines
    By GlynRD in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-17-2013, 07:57 AM
  6. Concatenate address lines of varying number
    By tone640 in forum Excel General
    Replies: 4
    Last Post: 08-08-2011, 08:18 AM
  7. Concatenate into 1 cell and drop down lines?
    By Jeff in forum Excel General
    Replies: 4
    Last Post: 07-06-2006, 03:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1