LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Duplicate Rows - Combining and Flipping

I have an extract from a student information system in Excel that
looks like this.

Student Class Grade Quarter
John Chemistry 70 1
John Chemistry 80 2
John Math 95 1
John Math 100 2
Alice Chemistry 67 1
Alice Chemistry 47 2
Alice Math 88 1
Alice Math 85 2

What I would like is this:

John 70 80 95 100
Alice 67 47 88 85

However, since there are hundreds of students, this would be an
extreme pain to do by hand. Is there any built-in formula or function
in Excel that can do this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining multiple rows with duplicate info -- help! Michael[_8_] Excel Discussion (Misc queries) 1 November 24th 09 06:34 PM
Combining duplicate rows into one ceci Excel Discussion (Misc queries) 2 February 4th 09 02:42 AM
Combining data from column while deleting duplicate rows [email protected] Excel Programming 1 January 14th 08 02:01 AM
combining duplicate rows jezzica85 Excel Discussion (Misc queries) 1 March 18th 06 02:30 PM
Combining duplicate records(rows) Jen Excel Worksheet Functions 3 February 16th 05 03:54 PM


All times are GMT +1. The time now is 01:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"