Narrtion required

[m9vukyem]

i downloaded bank statment in excel format in which narrtion contains multiple lines now i want to in single line formula required to upload data into tally software.


please provide me a formula

 

[pecoflyer]

?? Narrtion??

 

[m9vukyem]

By mistake complete file attached

here is my requirement

 

[p45cal]

In haste (could be a lot better), in cell G2 something along the lines of:
=IF(A2="","",CONCAT(OFFSET(C2,,,IFERROR(MATCH(TRUE,LEN(TRIM(A3:A14))>0,0),10))))
copied down.
Asumes no more than 12 rows need concatenating and will look beyond the bottom of the table, so be aware of that.

 

[shili12]

?? Narrtion??

Narration: Noun

A message that tells the particulars of an act or occurrence or course of events; presented in writing or drama or cinema or as a radio or television program

 

[pecoflyer]

Narration: Noun
A message that tells the particulars of an act or occurrence or course of events; presented in writing or drama or cinema or as a radio or television program

Sure, but "Narrtion" is quite new to me...

 

[AlanSidman]

Here is a power query solution. @pecoflyer -- no idea what a narrtion is either

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Value Dt.", type date}, {"Details", type text}, {"Chq No.", Int64.Type}, {"Debit", Int64.Type}, {"Credit", Int64.Type}}),
    #"Filled Down" = Table.FillDown(#"Changed Type",{"Value Dt."}),
    #"Grouped Rows" = Table.Group(#"Filled Down", {"Value Dt."}, {{"Data", each Text.Combine([Details], " "), type text}})
in
    #"Grouped Rows"

 

[m9vukyem]

Narration means details of the Transaction

Provide me formula

 

[pecoflyer]

As you did not see fit to at least acknowledge Alan's work, and the way you ask for help ( "Provide me formula"), I am adding you to my " Ignore" list.
Good luck

 

[shili12]

i tried with alan's formula but i cant see values. Am i going wrong somewhere ?

 

[p45cal]

Provide me formula

That looks like a command. At least the first time you included a 'please'.
I suggest you take a long walk on a short pier.