LinkBack URL
About LinkBacks
Combining multiple rows into one column without losing data
So, I'm working on a workaround to create patient statements for the business I work for. The current patient statements in Dentrix Ascend are pretty messed up and are too confusing for our customers. I have exported several different reports into excel to get the information I need. The end result of this is to create one row for each patient with all of the data and then to export the complete table into Microsoft Access so I can create a template and print out all of the patient statements from there. My problem is that it is really hard to get the information that I need in the format I need it. I managed to export a document with the charges for each patient, however, there is a separate row for each charge for each patient. I need to move all of the information for each patient from multiple rows to a single row without losing any of the data. There are 4 columns per row: patient name, date, procedure description, and amount. I don't want to combine everything into one column, like I have seen forumns for online. I need each piece of data to stay in their separate cells so I can put a total column at the end. But with roughly 25,000 rows, moving everything manually is a nightmare. Is there ANY way to do this other than manually?
Register To Reply
Bookmarks