I have the following file:


CUST# Code
------ -------
0001 A
5555 A
5555 Z
5555 B
6666 A
8888 A
8888 Z



Is there a simple way in SQL or QM or Query to make it look like:

Or is a pgm required?



Cust# CodeA CodeB CodeZ
------ ------- ------- --------
0001 A
5555 A B Z
6666 A
8888 A Z


Assume physical files exist in the formats shown above.


End result desired is an excel spreadsheet.

What would this be called? Pivot table?

Thanks in advance!!






______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].