Posted to microsoft.public.excel.worksheet.functions

Ting Li

external usenet poster

Posts: 2

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sorting column data	Matt T	Excel Worksheet Functions	2	June 1st 07 02:34 PM
Sorting Data From One Column into Multiple Columns	Justin Hoffmann	Excel Worksheet Functions	2	July 12th 06 04:15 PM
Help sorting data into own column	skint	Excel Discussion (Misc queries)	1	April 7th 06 10:18 PM
Sorting Data in a column	BigAndy	Excel Discussion (Misc queries)	1	September 13th 05 10:05 AM
Linking sheets when sorting row and column data	Sean 3DD	Excel Worksheet Functions	0	January 5th 05 12:21 PM

All times are GMT +1. The time now is 07:10 PM.

About Us

"It's about Microsoft Excel"