[FIXED] How tranpose the data of more than 1 cell to only 1 cell on google sheets?

Issue

I have the following column :

A1
Miu Kei Yuk
3354
of
2018
8 April 2022

and need to separate it into 3 columns : 3354 of 2018 Miu Kei Yuk 8 April 2022

So the first and the fifth row are correct, but the row number 2, 3 and 4 needs to be in only 1 cell.

I tried transpose(A1:A5) but iu results in :

Miu Kei Yuk domingo, março 07, 1909 of  2018    8 April 2022

Is it possible to do it ?

Solution

try:

={A2&" "&A3&" "&A4, A1, A5}

or:

={A2&" "&A3&" "&A4\ A1\ A5}

Answered By - player0

Answer Checked By - Dawn Plyler (PHPFixing Volunteer)