Office Software Thread, Excel - Creating lists of data in Technical; Hi
I can do this manually but wondering if there is a macro or some other automatic way to do ...
1st March 2011, 03:21 PM #1
- Rep Power
Excel - Creating lists of data
I can do this manually but wondering if there is a macro or some other automatic way to do this.
I have two columns of data:
Pupil ID | Set ID
I want to take this and change it so that each pupil id is listed against each individual set id once.
Then do the same for the next pupil id, and so on until each pupil is associated once with each set id.
I can do this manually but it takes too long.
Is there an easier way to sort the data this way?
1st March 2011, 03:55 PM #2
I'm not sure what you're trying to achieve, are you just sorting the list by Pupil ID? If so, just use Excel's sort function...
If the problem is that the pupil number is being listed against the same Set ID multiple times, in Excel 2007 onwards you can sort them by Pupil ID then use the Remove Duplicates tool...
Sorry I'm just not sure what you're trying to do here
1st March 2011, 03:57 PM #3
Not sure about whether it is possible in Excel, but I would go about this in MSAccess - two tables, each containing one of each of the two columns of data, then a query taking the two tables in would combine them with every possible combination, this can then be exported back to Excel.
Likely to take just a few minutes.
1st March 2011, 04:25 PM #4
- Rep Power
Thanks a lot, that worked a treat. Two tables, join them and then a query, export into excel, bingo. That will save me a lot of time.
Originally Posted by limbo
By ranj in forum Office Software
Last Post: 11th June 2010, 10:23 PM
By projector1 in forum How do you do....it?
Last Post: 24th September 2009, 02:15 PM
By Stuart_C in forum MIS Systems
Last Post: 14th September 2009, 05:35 PM
By Mr_M_Cox in forum Windows
Last Post: 31st October 2008, 12:43 PM
By danIT in forum General Chat
Last Post: 14th February 2008, 03:14 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)