Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

3 Answers

Changing data in table to rows

Hi, Say I have data organized the following way: A D G B E C F And I want it transformed to show this way A B C D E F G What's the fastest way of doing it?

Posted by on

  • Dinoza
    Dinoza Aug 14, 2007

    Thanks guys.
    The problem is that I have over 100,000 rows and 10 columns. I was hoping for something more quick.

    Let me know if you can think of something.


  • mapsoft Nov 20, 2007

    Say I have data organized the following way:

    A D G
    B E
    C F

    And I want it transformed to show this way


    What's the fastest way of doing it?



3 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 151 Answers

In excel there is you copy the row or column you want. and select that much number of respective column or row. Then right-click on it and do 'paste special' In paste special select 'transpose'. You rows will be converted into columns and vice versa.

Posted on Sep 28, 2007

  • Level 1:

    An expert who has achieved level 1.


    An expert that has over 10 points.


    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 9 Answers

In Excel you can use the "Paste-Special..." action from the "Edit" menu. Select for example "A|D|G" and paste it using "Paste Special...", and select the transform entry in the dialog. Do the same with the other rows. Then select the data and sort ascending.

Posted on Aug 07, 2007

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that has over 10 points.


    An expert whose answer got voted for 2 times.

  • Contributor
  • 34 Answers

In what program? In Excel, you could simply select D,E,F and drag under A,B,C. Same with G

Posted on Aug 07, 2007

1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

2 Answers

What is excel


Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.


Jun 04, 2011 | Microsoft Excel for PC


Deleting Rows & Columns from the table

You can also remove columns or rows from the table. Once a row or column is deleted, it can be undeleted by using Undo command. You can delete the columns or rows or cells by using one of the following ways.
By Table Menu
To delete a row or column by Table menu, follow these steps.
  • Place the insertion point in the column or row that is to be deleted.
  • Click Table menu and then select "Delete" from Table menu, a submenu of Delete is displayed.
  • Select Columns or Rows or Cells command to delete the selected element (column or row or cell) from the table.
By Popup Menu
To delete a row or column by popup menu, follow these steps.
  • Select the column's you want to delete.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Columns" command, the selected columns will be deleted.
  • Place the insertion point in the column or row that is to be deleted.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Cells" command, "Delete Cells" dialog box is appeared.
  • Select "Delete entire row" to delete a row or select "Delete entire column" to delete a column etc. from the dialog box and click "Ok" button.

on Jan 29, 2010 | Computers & Internet

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet

Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    2 Answers

    Access database was copied now no tables in dropdown list

    Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!

    Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.

    In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).

    Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).

    If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.

    You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.

    Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.

    And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.

    If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...

    Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

    1 Answer

    Linking tables in Oracle

    While I'm not saying it's not possible, it's not something Oracle (Or any relational database) is designed to support, so don't be surprised if this isn't possible or extremely difficult.

    Relational databases support predictable relationships. IE: Table 1 relates to Table 2 in a given way.

    Relational databases do not support varied relationships depending on the data in each row. The query engines simply can not join data this way.

    If you provide me more details about your data, I might be able to propose a table structure that doesn't require a different table for each row of data in ROOT.

    Feb 12, 2009 | Microsoft Computers & Internet

    1 Answer

    Steps and definition of ReOrganizing mysql Database

    I can't really tell what you mean by "re-organizing" a database. Some things this could include are:

    • Creating new tables
    • Deleting unused tables
    • Changing the structure of the database's tables (adding fields, removing fields, moving fields between tables, etc.)

    Aug 28, 2008 | Sun MySQL

    5 Answers

    Formula required

    at first select the 1st page data and select data-subtotal from the upper menu list.
    then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

    If not solved pls get me that data as to reference.


    Dec 04, 2007 | Microsoft Excel for PC

    2 Answers

    Budgets in excel

    Dear Madiha35,


    I would recommend the use of the Table Function in Excel.


    Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.


    Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.


    Excel 2007 had a budget format workbook

    New workbook, Select Budgets in the last hand navigation, Select Personal Budget.


    Step 1:  Enter your data into the worksheet.


    Step 2:  Create Table

                 Highlight the relevant data

                 On the insert tab, click on Table


    Step 3:  Verify Table range is correct, Click OK


    Step 4:  Select the cell you where you wish to Sum Data.

             Click on Autosum.


    Step 5:  To Insert new data

             Click on the sum row in the table, (Not the entire worksheet row)

             Right click, Insert, Insert Table rows from above


    Step 6:  Enter new data in row


    Step 7:  Data is automatically calculated in formula.

    Oct 22, 2007 | Computers & Internet

    1 Answer

    Access Pasting Multiple data in the table

    When pasting data between tables, you have to make certain to select the exact number of rows and columns that you are going to paste into. For example, if you are pasting ten rows and ten columns of data, select (highlight in) from source table, Control C to copy, then go to destination table, select (highlight) ten rows and ten columns, then paste, either by right click and paste, or Control V.

    This should solve your issue, but if not please post back. Thanks for rating FixYa!

    Oct 03, 2007 | Microsoft Office Standard for PC

    4 Answers

    Running SQL queries on Excel

    Another way to do it is to use the SQL Drill freeware Excel addin (

    Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

    Not finding what you are looking for?
    Microsoft Office 2003 Basic Edition English (s55-00066) for PC Logo

    Related Topics:

    130 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2970 Answers

    Piyal Perera
    Piyal Perera

    Level 3 Expert

    528 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18420 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides