Hey guys
I need to create a single table from several other tables in other sheets.
i.e.
Sheet 1 has:
Student ID # Qualification Level
0457 Certificate IV
0384 Diploma
0384 Certificate IV
1687 Certificate II
Note that it is possible for a Student ID to repeat but have a diferent qualification
Sheet 2 has:
Student ID # Qualification Level
0722 Certificate III
0605 Diploma
0941 Certificate II
I need a formula in Sheet 3 which knows how many entries are in Sheet 1 and returns them all, then in the next available line it begins to return all entries in Sheet 2. Sheet 3 should read:
Student ID # Qualification Level
0457 Certificate IV
0384 Diploma
0384 Certificate IV
1687 Certificate II
0722 Certificate III
0605 Diploma
0941 Certificate II
The same example is attached in the spreadsheet.
Thanks guys
Stan
Bookmarks