TRANSPOSE Function

### How to Swap Columns and Rows in Excel (9 Easy Ways)

Are you struggling with analyzing or viewing a complex Excel dataset? If so, swapping the columns and rows in your Excel spreadsheet might be the ...

### Intersection of Two Columns in Excel (7 Easy Methods)

While working in Microsoft Excel sometimes we need to find intersection of two columns. But sometimes it becomes difficult if you are not aware of ...

### How to Apply Vector Formula in Excel (5 Suitable Examples)

If you are looking for a vector formula in Excel, you have come to the right place. Here, we will walk you through 5 easy examples of doing the task ...

### How to Find External Data Connections in Excel (5 Quick Tricks)

In this article, we will show how to find External Data Connections in Excel. External Data Connections are the reference to the data in another ...

### How to Create Price Tags in Excel (with Quick Steps)

The best way to create a price tag in Excel is when Excel users have data in Excel or maybe have expertise in Excel. In this article, we will ...

### How to Convert Decimal to Binary in Excel (3 Quick Methods)

Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can perform tedious calculations in the blink of an eye. In ...

### How to Copy Horizontal and Paste Vertical in Excel

While working in Microsoft Excel sometimes we need to copy horizontal data and paste them vertically to rearrange data. It might seem difficult to ...

### How to Make a Correlation Table in Excel (5 Handy Ways)

If you are trying to make a correlation table in Excel, then this article will help you a lot. A correlation table defines the relationship between ...

### How to Create Array Formula in Excel (13 Suitable Examples)

Creation and usage of the Array formula is an essential part of Excel operations. The use of Multiple and Single-cell Array formulas is essential for ...

### How to Convert Column to Text with Delimiter in Excel

We often need a list in a column in an Excel sheet to arrange in a horizontal orientation. We will need a delimiter to separate the texts in that ...

### Combine CONCATENATE & TRANSPOSE Functions in Excel

Looking for ways to use CONCATENATE & TRANSPOSE functions together in Excel? Then, this is the right place for you. We usually use these two ...

### How to Concatenate Arrays in Excel (With 2 Conditions)

While working in Excel, we sometimes need to combine texts located in several rows and columns. In this case, the processes to concatenate these ...

### How to Concatenate Number and Text in Excel (6 Methods)

Concatenate in Excel means linking two or more cells together into a chain or series of data. While dealing with a large dataset, you may need to ...

### How to Split Text to Columns Automatically with Formula in Excel

Sometimes we face the necessity of organising text in specific columns. We can use Text to Columns feature, apply different formula or VBA code. In ...

### How to Create Minimum Variance Portfolio in Excel (2 Examples)

The article will show you how to create a Minimum Variance Portfolio in Excel. A properly organized portfolio with individual risky properties or ...

Advanced Excel Exercises with Solutions PDF