Hi all,

I have a spreadsheet along the following lines:

Id Attrib 1 Attrib 2 Attrib 3 ...
1 x
1 x
1 x
2 x
2 x
3 x
3 x

I need to 'condense' this, i.e. reduce the replication of information-
represent the binary flags under 1 id:

Id Attrib 1 Attrib 2 Attrib 3 ...
1 x x x
2 x x
3 x x

Is this doable by VB macro? I have tired all sorts of other ways of
manipulating the data, but I am stuck using excel and would greatly
appreciate any help someone might give me.

Thanks in advance!


--
rivvorz
------------------------------------------------------------------------
rivvorz's Profile: http://www.excelforum.com/member.php...o&userid=33450
View this thread: http://www.excelforum.com/showthread...hreadid=532584