David, let me know if this should not post here.
 
I have a file that contains data looks something like this:
 
Phone#         Phone Ext#    Feature
1234567980      1234567       ABC   
1234567980      1234567       DEF   
1234567980      1234567       XXX   
1234569999      9994567       GXX   
1234569999      9994565       XXA   
6019991234                    ABC
 
 
Is there a easy way to transform it to look like this using interavice SQL if I 
know that the most feauture an unquie phone+ext can have is 8?
 
Phone#      PhoneExt#     Feat1    Feat2    Feat3    Feat4    Feat5    Feat6    
Feat7    Feat8            
1234567980   1234567       ABC      DEF      XXX
1234569999   9994567       GXX      XXA 
6019991234                 ABC 
   
 

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2026 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.