Microsoft Office Standard for PC Logo

Related Topics:

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 Anonymous on

Ad

1 Answer

Anonymous

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Mentor:

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

    Governor:

    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

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1helpful
3answers

How to Convert NSF to PST?

PST is a safer file format than NSF, and therefore many of the time, users decide to convert their NSF files to PST files. In the same row, users prefer Outlook over Lotus Notes because it is provided by prominent tech giant Microsoft and comes as a part of Microsoft Suite. This task is not as easy as it looks, it needs expertise in data conversion. There is a manual method, and a varied range of third-party tools are available for this task. Generally, users rely on third-party tools, and this is because the manual method does not meet the expectations of the users. Weeom NSF to PST Converter tool is one such tool that securely converts NSF to PST with the effective or desired resultant PST. There are many features available in this tool, for say, PST split, Filters, duplicity remover ability, and on and on.
Well, if you want to look at its works, you can use its free demo version.

Visit : https://www.weeom.com/nsf-to-pst-converter.php
0helpful
1answer

SWAPPING REAR SEATS AND MIDDLE ROW

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,.
0helpful
1answer

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
4helpful
1answer

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.
0helpful
1answer

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
1helpful
1answer

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!
0helpful
1answer

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
0helpful
1answer

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.
=ADDRESS(MATCH(F1,A1:A20,0),1,1,TRUE)
And just like the first option, for the 2nd column, put the formula in D2 and change the column reference 'A' to 'B'.
1helpful
3answers

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.
0helpful
1answer

Excel

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.

 

 

 

Not finding what you are looking for?

54 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13435 Answers

David Shaub

Level 3 Expert

2991 Answers

Mandeep  Singh
Mandeep Singh

Level 3 Expert

1184 Answers

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

Answer questions

Manuals & User Guides

Loading...