Thank you so much for your help.
But I want to show each of them in independent boxes like:
A B C D E F
1 B A B A
2 B A
3 A
4
5

Since my data base has more than 1000 entries, I am now looking for some
fast ways to change them into the pattern like above.


"Gary''s Student" wrote:

Use:

=A1 & " " & A3 & " " & A1 & " " & A3
=A2 & " " & A4
=" " & A3

--
Gary''s Student - gsnu200727


"Ting Li" wrote:

I have got a column of data like below:
B
B
A
A
A
B
A

how could I use the excel function to make it becomes the following?
B A B A
B A
A