Reshape Columns


For the output array, columns are accessed left to right. Within each column, values are accessed top to bottom.


We consider the same sample data. Here, we want to arrange the Interest for each Company in columns.

Step 1

We select column D values in the Source.

Step 2

As we know we want 3 columns in the result, we will provide Columns as 3 and as we want to read the values top to bottom in columns from source, we will select Columns.

Step 3

The values are arranged as per columns in the result and the function is

Some Examples:

1) Both Rows and Columns are given

Let’s say we want to arrange the Amount values of only the first 2 Companies in columns.

As we know the number of rows and columns we want in our result array, we provide Rows as 5 and columns as 2.

2) Constant Values

Let us take the below sample data where we have to fill the Payment Mode in column G with the values from Column B. The additional rows in New Transaction ID will have Payment Mode as UPI.

In Reshape, provide Rows as of the F2 and columns as 1. We will select Use a constant value and provide the value “UPI”

3) Reshape a constant value

In the below example, we want to fill the category column in the table with the value in cell B2.

We select the DataRange as cell B2 and provide rows and columns as shown below.