Sorting multiple entries in excel
August 12, 2005 4:06 PM Subscribe
How can I re-sort repetitive columns of data in Excel?
My boyfriend is attempting to sort data imported from SQL in an Excel spreadsheet. The original data is listed by: Date, Procedure Code, and "Count" (Amount of times that code was entered on a given day). There are multiple procedure codes for each date--although not each code shows up for each date.
He would like to resort it so that each row is a date and each column is a code, with the intersecting cell being the "count" for the code on that date.
Or...visually...he would like to go from a chart that looks like the one on the left to one that looks like the chart on the right in this screen capture.
There is a huge, huge amount of data--so this isn't doable by hand. Anybody know how to write a formula for something like this?
My boyfriend is attempting to sort data imported from SQL in an Excel spreadsheet. The original data is listed by: Date, Procedure Code, and "Count" (Amount of times that code was entered on a given day). There are multiple procedure codes for each date--although not each code shows up for each date.
He would like to resort it so that each row is a date and each column is a code, with the intersecting cell being the "count" for the code on that date.
Or...visually...he would like to go from a chart that looks like the one on the left to one that looks like the chart on the right in this screen capture.
There is a huge, huge amount of data--so this isn't doable by hand. Anybody know how to write a formula for something like this?
Use the Pivot Table feature, with the date across the top and the code along the side. Then bring up the properties for the body of the table and select the formula you want.
posted by randomstriker at 4:25 PM on August 12, 2005
posted by randomstriker at 4:25 PM on August 12, 2005
Response by poster: Sorry about the link. That should be fixed now.
posted by divka at 5:38 AM on August 13, 2005
posted by divka at 5:38 AM on August 13, 2005
Response by poster: Pivot tables work great for this. Thanks!
posted by divka at 7:59 AM on August 13, 2005
posted by divka at 7:59 AM on August 13, 2005
« Older Where's the best place to find video clips of the... | Is Sicily a good place to go scuba diving? Newer »
This thread is closed to new comments.
if the data is in three columns as described, you should be able to go to the pivot table wizard [data -> pivot table] and create a table in the matrix you're looking for. you'll drag count into the data area, date into row and code into the column.
you may need to change if excel should "count" the data in the count field or "sum" but that would depend on your application.
posted by birdherder at 4:15 PM on August 12, 2005