Build String From Excel Table Output From Power Query

[wsnyder]

Hi all,

I have some Tables that are output from Power Query
I'm currently building a string from some of the cells:

="•"&D7&CHAR(10)&
"•"&D8&CHAR(10)&
"•"&D9&CHAR(10)&
"•"&D10&CHAR(10)&
"•"&D11

Problem is when data is more lines or less lines.
Any ideas on a better process?

Thanks,
-w

 

[GraH]

Maybe use the table structured reference and something like

textjoin(char(10),true, table[ColumnD])

But why not do this Inside PQ?

Text.Combine(PreviousStep[Column4], "#(lf)")

 

[wsnyder]

Thanks GraH,

I'm trying to combine in PQ, but getting an error

let
    Source = WM,
    #"Filtered Rows" = Table.SelectRows(Source, each ([Market] = "x")),
    #"Added Custom" = Table.AddColumn(#"Filtered Rows", "BL_Merge", each Text.Combine([Bullet_Long],"#(lf)")),
    BL_Merge = #"Added Custom"{0}[BL_Merge]
in
    BL_Merge

Error:

Expression.Error: We cannot convert the value "• Blah, blah, blah" to type List.

Thanks,
-w

 

[GraH]

Stop the query at filtered rows.
Reference the query.
Select the column bullet_long and remove other columns.
Click on the fx icon of the formula bar. Keep the step name that get's inserted. Then precede this with Text.Combine(StepName[bullet_long], Delimiter).

 

[wsnyder]

Thanks GraH,

That did exactly what I needed!

let
    Source = x,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Bullet_Long"}),
    Custom1 = Text.Combine(#"Removed Other Columns"[Bullet_Long],"#(lf)")
in
    Custom1

Thanks,
-w

 

[GraH]

Good to read. Thanks .