We are at the end of our fiscal year and have started an data mining project for grants and foundations. Right now I am working through a 27k excel sheet. Through clever data sorting and conditional formatting I have gotten that number down to 17k. We are trying to squeeze out our unique attendance from this list. The bulk of the work is combining multiple line items into one. For example, we have a patron who has purchased 4 tickets to Westside Story. One of the party is a youth, one is a Young professional, and the rest are adults. When I out put the data through execute and output set, I end up with three rows of data that I have to combine manually.
Is it possible to build a query element that combines all these rows into one? Has anyone had any success building one? Am I using the right tool for this kind of analysis? I have some experience with building query elements with mixed success. I also have some basic SQL skills.
Any help would be appreciated.
Thank you,
Jason Buehrer
Hi Jason,
There is a quick little macro in Excel that I found that combines multiple rows into one, based on a unique id (customer id when dealing with tess data, obviously). If you want me to send it to you, you can email me at jkeener@motopera.org