<p>I have a raw data file that I download daily and I want to create a simplifie

Question

<p>I have a raw data file that I download daily and I want to create a simplified automatic sheet that is easier to read. My question is, I want to take the values from a column from the raw data and have them listed only once in the simplified list. Let me phrase this better.</p>
<p>RAW DATA SHEET:</p>
<p>Column</p>
<p>a</p>
<p>a</p>
<p>a</p>
<p>a</p>
<p>a</p>
<p>b</p>
<p>b</p>
<p>b</p>
<p>b</p>
<p>b</p>
<p>c</p>
<p>c</p>
<p>c</p>
<p>c</p>
<p>c</p>
<p>What I want to do this is to compile this into a seperate sheet as:&#160;</p>
<p>Column</p>
<p>a</p>
<p>b</p>
<p>c</p>
<p>Is there a formula to create this, I would like the sheet to update automatically if a new project is added, E.G. if there are another 5 D's added to the raw data, I want it to automatically show up in the compiled sheet.&#160;</p>
<p>Thanks!</p>

Explanation / Answer

Do you have a sample file I can look at?

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.