R
Richard Brust
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/tutorial...b340-2e8c8cefd9d7/net-beginners-guide-to.aspx
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/tutorial...b340-2e8c8cefd9d7/net-beginners-guide-to.aspx