Merge splitted cells in new cloumn

[LostInWoods]

Hello,

I imported a table form .txt file but I would like to modify table. I woud like to concatenate values form same cloumn because cell values are splitted in half.

Current table:

Sample	Text spl
	itted in half

Desired table:

Sample	Text spl	Text splitted in half
	itted in half

How to perform such manipulation in power query editor?

[Vijay_A_Verma · Accepted solution]

See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCk7MLchJVdJRCkmtKFEoLshRitWJVgLyM0tKUlMUMvMUMhJz0sCCEKWGULWJScnIylNS09KzgOpiAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Added Index" = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
    #"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each if Number.Mod([Index],2)=0 then [Column2]&#"Added Index"[Column2]{[Index]+1} else null),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Index"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([Custom] <> null))
in
    #"Filtered Rows"

[LostInWoods]

Hello,

Thank you for quick help.

I got error msg, in every 2nd row (where conditon is true):

Expression.Error: "XXX" value can not convert to: List.
Details:
Value=XXX
Type=[Type]

I think it would be OK if I could convert text.

[Vijay_A_Verma]

Can you post few lines of your dataset capturing column names as well so that I can understand the pattern and accordingly modify the solution?

[LostInWoods]

Sorry, it was my mistake (I thought I can live without crtl+C and started typing). Your solution works perfectly.

Much appreciated for your help.