+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    30

    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

    Heading:

    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?

  2. #2
    Face-Man's Avatar
    Join Date
    Dec 2005
    Location
    London
    Posts
    577
    Thank Post
    11
    Thanked 58 Times in 40 Posts
    Rep Power
    71

    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:



SHARE:
+ Post New Thread

Similar Threads

  1. excel spreadsheet editable online
    By Uraken in forum Web Development
    Replies: 4
    Last Post: 21st November 2007, 05:23 PM
  2. SIMS .net Permissions Spreadsheet
    By Heebeejeebee in forum MIS Systems
    Replies: 4
    Last Post: 7th June 2007, 08:59 AM
  3. Image manipulation tools
    By wesleyw in forum How do you do....it?
    Replies: 3
    Last Post: 19th April 2007, 03:48 PM
  4. GNU Image Manipulation Program (GIMP)
    By _Bat_ in forum Downloads
    Replies: 1
    Last Post: 30th June 2006, 11:32 PM
  5. google spreadsheet
    By russdev in forum Educational Software
    Replies: 15
    Last Post: 15th June 2006, 07:42 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •