| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are access query results different in Excel | Excel Discussion (Misc queries) | |||
| exporting from sql query results to a excel workbook | Excel Programming | |||
| Access query results to Excel | Excel Discussion (Misc queries) | |||
| VBA - query an Access table - results in Excel | Excel Programming | |||
| Complex Query Not Able To Get Results in Excel | Excel Programming | |||
Threaded Mode
