First Post: Listing variables in a Column

[RossiV]

Hey All, new to MrExcel so please be kind, I fear my question may be viewed as simple by some.

I have a datasheet with 6000+ entries. One column has lists of companies, of which there are around 300 and their are entered into this column multiple times. I organized and identified the largest ones but a work file of 6000 is making it a long process to find every single company listed, paste their name onto a separate table to analyses. Is there a formula to take all the different company names and arrange them in a list OR list them just once in a column next to it? I will have to do this again and the analysis of the companies is the most important this but I find I need to spend all evening steadily combing the haystack for needles!

Any advice is appreciated!

Thank you

RossiV

 

[Kyle123]

Pivot the list, put companies in the rows section, then copy and paste them to where you want

 

[Excellling]

You can try:

Say your data starts in A1, click on B1 and go to data, sort & filter, advanced.
Make the list range the entire range of companies, say A1:A6000
Tick unique records only and choose 'copy to another location'
Click ok - should create a list of unique entries in the column to the right of your list of companies

 

[Excellling]

oh sorry in the dialog box in the 'copy to' section put B1

 

[RossiV]

Hey all, found the pivot table to work (after researching it) and Excelling sort and filter also did the trick. Found another method for those who may wander on here with the same question. Select and copy the column of data and click data then remove duplicates. Left me with the unique inputs in a seperate column. Thank you Kyle 123 and Excelling!

RossiV