Re-formatting
 

Hi,

Have 2 columns with 250 rows. Each value in A has a B value.
There are 15 different B values.
I need to write a Macro which will create another worksheet,
headings for each B value will all the associated A values underneath.
Below is a sample, many thanks


How do I get from

A B
1 a
2 b
3 a
4 a
5 b
6 b
7 a
8 a
9 c
10 c
.........
.....

TO:
a
1
3
4
7
8

b
2
5
6


c
9
10


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=530558