Move multiple rows into columns in Excel - when transpose does not work

Sometimes when you need to move data from rows to columns in a spreadsheet, a simple transpose operation does not work. This is a case i stumbled upon when I imported data to Excel from the WordPress forms plugin called Cforms II. I wanted the form input labels to be my column titles but transposing just wouldn’t cut it. But luckily I figured it out, so here’s a tutorial on how to move data from rows to columns in Excel.

Drop down list in Excel tutorial


This is a quick tutorial on how to create a drop down list in Excel. Type the following data into your spreadsheet:

Drop down list in excel data

Get first name and last name in Excel | Split full names

This is a tutorial on how to split first name and last name with a function in Microsoft Excel. We use function LEFT to get the name on the left side (usually first name) and RIGHT to get the name on the right side (usually last name).

Combine first name and last name in Excel | create email addresses for example

This is a quick tutorial on how to combine first name and last name in Microsoft Excel. You might want to create email addresses from your list of names for example, so use the CONCATENATE function.

Replace multiple characters in Excel

This is a quick tutorial on how to replace characters from a text string in Microsoft Excel. The SUBSTITUTE function comes in handy when creating email addresses for example and you have names with letters like ä, ö or ü. These letters need to be substituted with a, o and u.

Index Match tutorial in Excel - search with one or multiple criteria

Excel's Index Match-combo is very useful when you need to find a particular value or "a hey from a heystack" matching some key value - text or a number value.

As you might know already, the Lookup, Vlookup and Hlookup functions are also very useful, but if the source data is not static - the heys in the heystack move around and do not stay always on the same rows or columns, your best option is to use index match-combo.

Workdays in Excel tutorial

This is a quick tutorial on worday function in Microsoft Excel. Workday function returns a date for a working day before or after a given date. It excludes weekends and any dates identified as holidays.

Sentence case, lowercase and uppercase in Excel tutorial

This is a quick tutorial on how to change text to sentence case, lowercase and uppercase in Microsoft Excel. Change you text to sentence case with this function (assuming your text is in cell A1):

Round time to 30 min intervals | Round time to any interval you want in Excel

Round time down or up to nearest 30 minute interval - quick Microsoft Excel tutorial. If you need to round time up to nearest 30 min interval, use this function (presuming your time data is in cell A1):
=CEILING(A1;1/48)

Excel nested IF functions tutorial | Download free spreadsheet

This is an example of how use multiple nested IF functions in Excel. In this quick tutorial we will look for a certain value from multiple cells and print out either number 1 or number 2. The example can be seen in the image below.

Nested if functions in Excel tutorial