When you're configuring data in a Microsoft Excel worksheet, you may realize that the information you entered in rows makes better sense in columns or vice versa. For example, you're especially likely ...

Q. One of our clients sent me some data that is horizontal, but it needs to be vertical to load into our system. Is there an easy way to convert the data to the required format? A. You can easily ...

If you’ve ever worked with an enormous Excel spreadsheet, you’ll know just how daunting all those rows and columns can be. Once you’re over 10 or 15 different values and labels, it can get pretty ...

It's often useful to freeze header rows in place in Microsoft Excel to remember what type of data is in various columns as you scroll or search through a lengthy spreadsheet. You can also make sure ...

Do you want to split a single column of text into multiple columns in your Excel spreadsheet? Using the Text to Column feature, you can choose how to split the column up, fix the width, or split at ...

Every time Dave publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from Business ...