Question about Microsoft Office Standard for PC

1 Answer

Convert from Row to coloumn

Suppose I want to convert data from row to coloumn Pl suggest solution.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 3 tips or uploaded 2 video tips.


    An expert whose answer got voted for 20 times.

  • Expert
  • 112 Answers
Re: Convert from Row to coloumn

Do the following: copy the data and then choose paste special and check transpose. Let me know if this helped and please rate my solution. Best, D

Posted on Sep 03, 2007

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

SQL query to change date and/or time format

The function you're probably looking for is CONVERT. Here's an example (101 applies the format "mm/dd/yyyy", 108 applies "hh:nn:ss"):

SELECT CONVERT(varchar(10),getdate(),101) as JustDate, CONVERT(varchar(8), getdate(), 108) as JustTime


JustDate JustTime
---------- --------
09/24/2013 13:13:56

(1 row(s) affected)

Jul 15, 2013 | Microsoft SQL Server 2005 Standard Edition

1 Answer

When you inaserrt a cell into a row,all data in that row is shifted down true or false?

With most spreadsheet programs, false. Of course, the data in that row below the insertion point is usually pushed down but not the data above.

Feb 28, 2013 | Business & Productivity Software

1 Answer

What is the meaning of rows?

In Microsoft Excel, "rows" refer to data cells grouped together horizontally across a single line. The numbers on the far left of the screen refer to a row number. Similarly, the letters at the top of the workbook page refer to the columns.

Here is a picture to help:

In this example, there are 3 rows. All the cells in Row 1 contain the words "Row 1" and are color-coded orange. Likewise, All the cells in Row 2 are pink, and those in Row 3 are blue. Do note, however, that even though the boxes under the letter "F" aren't color-coded, they are still in the respective rows. Each color-coded line could extend for an infinite number of boxes, and each box of the same color would be part of that row.

If you find this solution helpful, please leave a positive rating!

Jun 22, 2011 | Microsoft Office Excel 2007 Full Version...

1 Answer

Doesn't remember there's a Header Row

You can try to select all data (except for the entire row which contain your header) and try to sort thru columns. This can sorted in ascending or descending order.

Jul 17, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Finding the correct row num

You would have to combine the use of 2 functions. The Address and Match funbctions.
Lets say the number you want the address of is located in cell F1 and you have 2 columns of numbers. One colum in Column A and the other in column B. I will give you 2 formulas. The 1st one will return just the row number. The 2nd one will return the cell address.

Option 1: Lets say you just want to know the row reference of the number in cell F1. Place this formula in cell D1. =MATCH(F1,A1:A20)
If you have another column ytou want the row number of, place the formula in lets say cell D2 and change the column references from 'A' to 'B'.

Option 2: If you want the cell reference, place this formula in cell D1 and D2 instead of the firt formula.
And just like the first option, for the 2nd column, put the formula in D2 and change the column reference 'A' to 'B'.

Feb 17, 2009 | Microsoft Excel for PC

1 Answer


lookup value = value searched

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x

Nov 13, 2008 | Business & Productivity Software

1 Answer

The value cannot be added to this new row until the row has been committed

It sounds like you are using an ADO data set, which is probably one of the more difficult, especially for a beginner. What you are seeing is that the data does not update related controls until the data has been committed to the row you are updating. Set the Binding.DataSourceUpdateMode to DataSourceUpdateMode.OnPropertyChanged.

Or, depending on the version of Access you are using, the option may be somewhat different. The point is to tell the control to update "on change" - so that once your data is in there (a change) the other items you want to happen will occur, as the row has been committed (recorded). Thanks for rating FixYa!

May 07, 2008 | Microsoft Office Professional 2007 Full...

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 | Business & Productivity Software

1 Answer


Prepare table having coloumns Client, Premium Amount , Month.


Now take Pivot table of the above table. Take Field 'Month' in Page field and Client in 'Row' field and sum of amount in 'Data field'.


If you refresh the data and select the required month you will get the desired information.




Sep 11, 2007 | Microsoft Office Standard for PC

3 Answers

Changing data in table to rows

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

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

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

43 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides