consoldating data

[tincan85]

I am trying to create a way to make several lines that have the same sample with different tests consolidate into a single line. I know this is simple but can't seem to figure it out. see below. ANy ideas?

Sample Id</SPAN>	Sample Name</SPAN>	Lot#</SPAN>	Concentration</SPAN>	Test</SPAN>	Analysis Date</SPAN>	Specifications</SPAN>	Results</SPAN>	Potency</SPAN>
1</SPAN>	samplea</SPAN>	PHEN03212013JVM100</SPAN>	1mL/5mL</SPAN>	testa</SPAN>	3/27/2013</SPAN>	<1 EU/mL</SPAN>	Pass</SPAN>
1</SPAN>	samplea</SPAN>	PHEN03212013JVM100</SPAN>	1mL/5mL</SPAN>	testb</SPAN>	Day 3 (Neg.)</SPAN>
2</SPAN>	sample</SPAN>	PHEN031913KH100</SPAN>	1mL/5mL</SPAN>	testa</SPAN>	3/27/2013</SPAN>	<1 EU/mL</SPAN>	Pass</SPAN>
2</SPAN>	sample</SPAN>	PHEN031913KH100</SPAN>	1mL/5mL</SPAN>	Testb</SPAN>	Day 3 (Neg.)</SPAN>
2</SPAN>	sample</SPAN>	PHEN031913KH100</SPAN>	1mL/5mL</SPAN>	testc</SPAN>	3/27/2013</SPAN>	1</SPAN>	0.952</SPAN>	95.20%</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL><COL><COL span=2></COLGROUP>

 

[Trevor G]

Have you looked at Data and Advanced filter to create a unique list so you only get them once.

 

[tincan85]

I tried but it didn't work.