Results 1 to 8 of 8

How to concatenate Single Column which is split into Multiple Rows between two dates

Threaded View

zaska How to concatenate Single... 07-07-2020, 05:38 AM
XLent Re: How to concatenate Single... 07-07-2020, 06:26 AM
ORoos Re: How to concatenate Single... 07-07-2020, 06:35 AM
zaska Re: How to concatenate Single... 07-09-2020, 07:43 AM
jindon Re: How to concatenate Single... 07-07-2020, 06:42 AM
zaska Re: How to concatenate Single... 07-09-2020, 07:53 AM
jindon Re: How to concatenate Single... 07-09-2020, 08:02 AM
zaska Re: How to concatenate Single... 07-09-2020, 10:21 AM
  1. 07-07-2020, 05:38 AM #1
    zaska is offline
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    454

    How to concatenate Single Column which is split into Multiple Rows between two dates

    Hello,

    I have transaction data in Column "C", but this data is split across several rows in different columns between two transaction dates. I want to concatenate whole data into column "C".

    I tried the formula =IF(ISBLANK(G2),"",CONCAT(C2,A3:G3)) but I could get only data of One Row.

    I am herewith attaching the sample data containing the input and output sheet.

    I request seniors to guide me

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Concatenate single column in different rows
    By peixebotom in forum Excel General
    Replies: 1
    Last Post: 01-15-2020, 08:49 PM
  2. Split Single Row into multiple rows based on column data
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-29-2017, 01:57 PM
  3. [SOLVED] Multiple values in single cell (known column) split into rows with duplicate information
    By bwashbourne in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-06-2015, 05:00 PM
  4. Split single cell to multiple rows
    By jet706 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2015, 07:55 AM
  5. [SOLVED] Split Single Row into Multiple Rows
    By jfyang13 in forum Excel General
    Replies: 4
    Last Post: 10-27-2014, 10:39 AM
  6. Split single row into multiple rows
    By mbasam in forum Excel General
    Replies: 10
    Last Post: 09-12-2013, 06:09 PM
  7. [SOLVED] Need to split multiple rows of four column grouping into a single row
    By eaw$ in forum Excel General
    Replies: 10
    Last Post: 07-22-2012, 07:32 PM

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