You are here:

Using MS Access/duplicate rows query output


i have an access query that was exported to excel
this shows cath lab cases by number and procedure group with duplicates shown on separate rows.
is there a way to run the query to combine the duplicate procedure groups into one row? or a way to do that afte export to Excel?
ive attached shot of excel output. i had a way to combine the duplicates from another expert but couldnt get all the other columns to return after the combine.

You want to put all of the procedures together into one row? Same cell or multiple cells? Can you show me an example of what you want the finished product to look like?

I can't think of a quick and easy way to do this in Access or Excel without some kind of programming... so this may not be a quick solution.

Be sure to visit my web site and watch my FREE 2-hour-long Microsoft Access Video Tutorial

Richard Rost
599CD Computer Training

Using MS Access

All Answers

Answers by Expert:

Ask Experts


Richard Rost


I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.


I am the president of and I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at

©2016 All rights reserved.