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

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


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:

1 Answer


This type of modification is not recommended due to the structural limitations involved. In short it is unsafe to modify a car this may in case of a crash,.

Jul 23, 2012 | 2006 Kia Sedona 2.9

1 Answer

Can I convert my 2nd row seating from two bucket seats to a 3 seater bench in my 2009 Kia Sedona?

Did you ever find a solution to this problem? I too am looking to convert to bench seat in middle row

Nov 04, 2011 | 2009 Kia Sedona

1 Answer

How do you convert decimals to fractions?

With the decimal value on the screen, press 2nd F<>D.

F<>D is on the PRB key, second row, second column.

Jul 02, 2010 | Texas Instruments TI-30 XIIS Calculator

1 Answer

I need to print mailing labels imported from excel to word in columnar order instead of in order by rows across the page.

hi Samajane,

I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.

To convert the column wise data to row wise data.
1.Select the data in your worksheet.
2.Right Click -> Copy
3.Create a blank worksheet.
4.Goto Edit - > Paste Special
5.Check the Transponse Option
6.Press OK.

Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels

Dec 14, 2009 | Microsoft Windows XP Professional

1 Answer

Convert mdb to text files with vb 6.0 code

You will need to open the file using ADO and read the data into a recordset. Then loop through the rows and write them to a text file and use concatenation to format the rows in the text file as needed (CSV, tab delimited, whatever you need). Remember to add a vbCrLf after each row!

Apr 10, 2009 | LEAD Technologies Computers & Internet

1 Answer

Flexgrid with textbox

The arrow key will place you into the cell of your choice. In code you can determine the cell you are in by using the "Col" and "Row" properties. Here's a snippet for you:

Private Sub MSFlexGrid1_RowColChange()
Dim intCol As Integer
Dim intRow As Integer

intCol = MSFlexGrid1.Col
intRow = MSFlexGrid1.Row

Text1.Text = CStr(intCol) & " ; " & CStr(intRow)

End Sub

Mar 29, 2009 | Microsoft Visual Basic 6.0 for PC

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

3 Answers

S510 Keyboard Problem, Keys Dont Work, Everything Else Works,Ect-Mute

I had the same the problem. The cause was a corrupted encryption code. That is why only worked the keys that don't require encryption.
1) Install the Logitech software and restart.
2) The software will tell you to press CTRL-ALT-F12. This procedure resets the keyboard encryption and tells you to enter a new code.
3) If you already had the software installed simply press CTRL-ALT-F12 and follow the above procedure.

Mar 15, 2008 | Logitech Cordless Desktop S 510

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

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

Related Topics:

46 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

18419 Answers

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

Answer questions

Manuals & User Guides