Troubleshooting:Convert column headings into rows

Convert column headings into rows

Trying to convert A1 - M1 into A1 - A12 without having to cut and paste each column heading into its own row.

Solutions to the Problem Convert column headings into rows

Download Error Fixer for Free Now

Try this...

• Select B1:M1
• Home.Copy.....(or the keyboard shortcut: CTRL+C)
• Select A2
• Home.Paste.Transpose

(Transpose won't let you paste over the source)

• Then clear cells B1:M1

Does that help?

Ron Coderre
Microsoft MVP (2006 - 2010) - Excel

If any post answers your question, please mark it as the Answer (so it won't keep showing as an open item.)

Because of this Convert column headings into rows error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error Convert column headings into rows can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve Convert column headings into rows error or repair the corrupted and damaged Windows files, you will need a Convert column headings into rows error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

  1. Start the computer and log in as administrator
  2. Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
  3. Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
  4. On the new confirmation window that appears, click Next
  5. Restart your computer after the restoration has been completed

Recommended Method to Fix the Problem: Convert column headings into rows:

How to Fix Convert column headings into rows with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Run it, and it will scan your computer. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.

Related: Can't Get Admin. Tools To Work In Windows 7, Except Config.sys,Can't Delete Messages In My Deleted Items Folder,Can You Print From Web Browser In Home Netwrek With Windows 8 Or 7 Whitout Having A Server Installed?,Can You Create A Form From A Report? Arghh I Hope So!,Can't Delete A Link In Favorites (Vista IE9),Changing FONT Size On Labels (Office Starter 2010 / Windows 7 ),Chrome Browsers Windows Incorrectly Reported To Be Open,Certificate Error - Cannot Open Adobe Files To Read Unless I Purchase Adobe Professional,Cgi Extensions,Cant See Small Windows Above My Task Bar When I Move The Mouse Over The Explorer Icon In The Task Bar Anymore,Computer Sleeps Immediately Upon Wakeup From Hibernation,Computer Locks On Me And Only Ctrl + Alt + Delete Restores It After Lock Up,Computer Restarts When I Put My Admin Password,Conditional Formatting Highlight Cells If A Date Falls Within A Given Week,Computer Does Not Shut Down When Turning It Off.
Read More: Fast Solution to Error: Connection to Internet Explorer,[Solved] Control panel not responsive,Troubleshoot:Control Panel\\All Control Panel Items\\Notification Area Icons blank Error,Troubleshooter of Error: CONVERT classified pdf to word doc,Troubleshoot:converting all earlier works files to ms office 2003 files,chkdsk cannot continue in read-only mode.,Citrix Go To Meeting Downloader,Changing the range of a named range,Conditional Format Problem...,Connect to my network but no access to internet
by FileRundll32Exe33 | 2016-09-23 17:29