Troubleshoot:Converting data from one row to one column

Converting data from one row to one column

I have over 500 name delimited (last name, first name) all in one row.  I would like to convert that all to one column, with each person (last name, first name) per row.  I need step by step instructions.
 
Thanks in advance,
JT

Anwsers to the Problem Converting data from one row to one column

Download SmartPCFixer for Free Now

Select the row of data and Copy.
Move to the first cell in the column you want as a destination and right-click, then
Paste Special, Transpose.
The Transpose option is a checkbox in the lower right of the
Paste Special dialog.

Windows Error Reporting - To Fix Converting data from one row to one column

  1. Go to Start button.
  2. Open Control Panel.
  3. Go to Windows Error Reporting.
  4. Click on System and Maintenance, then click Problem Reports and Solutions.
  5. Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
  6. Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
  7. Next, click the Advanced settings link.
  8. Select Off to turn off Error Reporting.

Recommended Method to Fix the Problem: Converting data from one row to one column:

How to Fix Converting data from one row to one column with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed


Related: Can't Download Windows Updates,Can't Change Critical Battery Level Below 98% With APC UPS Battery Backup,Can Receive Bur Cant Send Emails On Home Wireless Network From My Laptop,Can't Download Several New Progams,Can You Change Column Widths On Different Pages Without Affecting Column Widths On Previous Pages?,Change A Cell Colour When Formula Is Overwritten In A Specified Range,Change PC Dock Icons,Cant Find My Disk Drive,Chkdsk Always Runs Immediately - How To Run At Boot?,Cant Use Chat Window In Win 7 Professional 64 Bit,Computer Will Not Allow Me To Click On Icons.,Computer Trying To Send Email Deleted In Outbox After They Failed To Send After Reply Clicked,Computer Goes To Sleep When Idle For Five Minutes,Computer Freeze While Watching A Videos,Computer Shuts Down Instead Of Going To Sleep Mode
Read More: Tech Support: Control Panel and Windows Explorer Won't Start,Solution to Problem: Continuous Blue Screens Occuring at Random,Troubleshoot:Control Panel\\All Control Panel Items\\Notification Area Icons blank Error,Troubleshooting:Controling PDF documents from inside Internet Explorer,Fast Solution to Error: Connections,cant install windows email, keeps asking for pop mail numbers have no idea thanks,CC update - should be easy, but it isn't.....,Changing Compression in scanned Documents,class not registered message when trying to download free fonts,Conditional Formatting Rows
[PR]
by FindCpuUsag2 | 2016-09-23 17:30