Sort words starts with first letter

[Robert Mika]

I have a spreadsheet with about 6000 words in one column.
I would like to sort them in alphabetic order in another sheet:
First column in this worksheet (A) will host only words starts on A second column B will host only B words.,etc..
I can created formula which will do this by starting always from the first row in the Words spreadsheet but this always will leave empty cells:
Words in column B will start in row where A words have finished, C where B finished and so one.

Any help?

 

[DonkeyOte]

You don't specify if all 6000 words are unique - and if not - whether you want to return a unique listing or not ?

Formula wise a basic approach would be something like:

Excel Workbook
	A	B
1	apple	3
2	banana	4
3	carrot	8
4	dog	10
5	aardvark	1
6	bell	5
7	bongo	7
8	bilbo	6
9	advert	2
10	elephant	11
11	cow	9
Words

and with the key in place generating the output on sheet A is pretty straightforward, ie:

Excel Workbook
	A	B	C	D	E
1	3	4	2	1	1
2	aardvark	banana	carrot	dog	elephant
3	advert	bell	cow
4	apple	bilbo
5		bongo
6
A

obviously the formulae are to be extended across the requisite matrix

 

[DonkeyOte]

I should add:

- in the above I've assumed unique - if not you would need to adjust the formulae accordingly (ie simplest to adjust Words B and add further COUNTIF based on running count of given word)

- I also omitted the formulae in use in row 1 of sheet A, namely:

A1: =COUNTIF(Words!$A$1:$A$6000,CHAR(64+COLUMNS($A1:A1))&"*")
copied across

 

[Robert Mika]

Thanks DonkeyOte,
This formula rocks.

I does what I want.

 

[hdabbas]

Greetings,

How the formulas would change if words are not unique?

Regards