Windows Thread, Excel - Spreadsheet Manipulation in Technical; I have a simple spread sheet which has been extracted from our reporting system and we now want to import ...
3rd July 2007, 01:40 PM #1
Excel - Spreadsheet Manipulation
I have a simple spread sheet which has been extracted from our reporting system and we now want to import it into our MIS.
We need the data as follows
Student_id F_Name S_Name SubjectGrade1 SubjectGrade1 SubjectGrade2 etc etc (Inline)
but it has come (Each grade on seperate line)
Student_id F_Name S_Name SubjectGrade1
Student_id F_Name S_Name SubjectGrade2
Student_id F_Name S_Name SubjectGrade3
Student_id F_Name S_Name SubjectGrade4
Can anyone suggest away in excel to easily change this data into the correct format?
IDG Tech News
3rd July 2007, 02:28 PM #2
Re: Excel - Spreadsheet Manipulation
I found this in excel help hope it is what you want to do
Move data between rows and columns
Copy the data in one or more columns or rows.
Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special.
In the Paste Special dialog box, select Transpose, and then click OK.
You'll find theTranspose check box in the lower-right corner of the dialog box:
By Uraken in forum Web Development
Last Post: 21st November 2007, 05:23 PM
By Heebeejeebee in forum MIS Systems
Last Post: 7th June 2007, 08:59 AM
By wesleyw in forum How do you do....it?
Last Post: 19th April 2007, 03:48 PM
By _Bat_ in forum Downloads
Last Post: 30th June 2006, 11:32 PM
By russdev in forum Educational Software
Last Post: 15th June 2006, 07:42 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)