I have data in following format (this is just an extract, there are 60
rows
under headings A-F)

A
J1
J2
J3

B
J77
J65
J31

C
J22
J11
J9

........
So I have cost Centres, A -F ( these can be in any order), with Jo
numbers
below(always prefixed by J), there can be any number of Job numbers.




I need to get the above into the order:


J1 A
J2 A
J3 A


J77 B
J65 B
J31 B


J22 C
J11 C
J9 C

Many Thank

--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=56631