where is the transpose button in excel 2010

This is Excel’s way of telling you that the contents in this column can’t fit the current width of the cell. One of the columns seems to contain only hash tag symbols. As you can see it’s quite difficult to read this data. Let’s start by opening up the first spreadsheet. I’m going to save these attachments to a document library and then I want to consolidate them into one single spreadsheet and clean up the data. The files contain information about prospects that we are going to share with an agency for analysis. These are Excel files with data that has been extracted from a database. Here I have an email from a colleague with two files attached. Let me show you! Changing column and row size (01:00) In this video I will show you how you can take a spreadsheet and how you can clean it up by changing the layout, deleting unwanted data and spotting and removing duplicates. Microsoft Excel 2010 is a great tool for cleaning up large sets of data, and if you learn the techniques and shortcuts you can quickly arrange the data in a format that makes sense to you. If you’re working with large sets of data you don’t want to waste your time by manually going through a large set of rows and columns. The data might have been extracted from a database in which case it isn’t very user friendly to read. From time to time you are given a data file that you need to clean up in order to make some sense of it.

Welcome to Business Productivity – I’m Ulrika Hedlund. Learn how to clean up data in Microsoft Excel 2010 Introduction (00:04)

Where is the transpose button in excel 2010