Thread: Format SQL Query results in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Brust Richard Brust is offline
external usenet poster
  
Posts: 2
Default Format SQL Query results in Excel
I will have a query that returns a lot of similiar fields per row, think:

Name1 Info1 Extra1
Name1 Info1 Extra2
Name1 Info1 Extra3
Name2 Info2 Extra4
Name2 Info2 Extra5

I'd like to be able to format it as such:

Name1 Info1 Extra1
Extra2
Extra3
Name2 Info2 Extra4
Extra5

Basically, remove repeating data withing a "set". I know how to do it via SQL (thanks to some help), but not within Excel. Thanks!

EggHeadCafe - Software Developer Portal of Choice
..NET Beginner's Guide To UI, Business, Data Layers
http://www.eggheadcafe.com/tutorials...-guide-to.aspx
Reply With QuoteReply With Quote