Thread: About sorting and extracting data in one column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default About sorting and extracting data in one column
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
Reply With QuoteReply With Quote