One Large Table Problem

Hello! I have one large table with about 250 fields and hundreds of records. Each field represents a computer and each record represents an app we have on that computer.



So my table looks like this:



Computer 1 .....Computer 2 .......Computer 250



Google............Java.................Microsoft

Windows.........Microsoft.............WinZip

Mediaplayer......Google.............Adobe



So as you can see, each computer can have the same apps as other computers. Some computers have apps that other computers do not have.



What I need is just a list of each app we have on all computers.



So my resulting table should have only one field for Apps and only show each app once. Ideally it would look like this:



Apps



Google

Java

Adobe

WinZip

Mediaplayer





I really don't know where to get started... Do a series of queries or macros? Any help is much appreciated! Thanks!

One Large Table Problem