How can I append the data in column A to the data in column B?

[Tome_05]

I am always grateful for your help.

Is there a way to add the data in column A to the data in column B and reflect the data in C to E as it is, as shown in the attached image?

thank you.

[Tome_05]

@ddpl 

thank you for your answer.

I tried this correspondence, but it did not work well because the same number was extracted continuously.

[ddpl]

@Tome_05 , the folowing solution work in power query,

First append the table with self.

then group by...

Create a custom column...

rest_2 = Table.AddIndexColumn([rest_1], "Index", 1)

Remove A and rest_1 column and expand the rest_2 column.

Create another custom column...

A&B = if [Index]>1 then [A] else [B]

Remove A, B & Index column and Bananas...