Thread: About sorting and extracting data in one column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ting Li Ting Li is offline
external usenet poster
  
Posts: 2
Default About sorting and extracting data in one column
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