R
Richard Dex
G'day,
A quick outline of my problem. I am trying to create a worksheet tha
takes data from other worksheets that list an output of time an
events for up to 200 runs of a simulation. What I have been able to d
is to bring the data into the worksheet and sort it such that th
duplicate data sorted. What I would like to do is to take th
individual rows and check for duplicate times and then, if a duplicat
exists, merge the rows such that the data remains in the origina
columns but is compressed into one row. Can any one help? I hav
attached a sample of the worksheet to illustrate where I am at.
Thank
Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51772
A quick outline of my problem. I am trying to create a worksheet tha
takes data from other worksheets that list an output of time an
events for up to 200 runs of a simulation. What I have been able to d
is to bring the data into the worksheet and sort it such that th
duplicate data sorted. What I would like to do is to take th
individual rows and check for duplicate times and then, if a duplicat
exists, merge the rows such that the data remains in the origina
columns but is compressed into one row. Can any one help? I hav
attached a sample of the worksheet to illustrate where I am at.
Thank
Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51772