0 votes

I have a dataset which looks like this:

And I want to convert it into something like this:

How can I achieve it in excel?

Feb 21, 2023 in Others 232 views

## 1 answer to this question.

0 votes

Using WRAPSROWS()

• Formula used in cell C2 --> Exclusively Applicable To MS365 Current Channel

```=WRAPROWS(A1:A10,2)
```

• Formula used in cell F2 --> Applicable To Excel 2010+ onwards

```=IFERROR(INDEX(\$A\$1:\$A\$10,COLUMNS(\$F\$2:F2)+(ROWS(F\$2:F2)-1)*2),"")
```

• Formula used in cell I2 --> Applicable To Excel 2021+ onwards

```=INDEX(A:A,SEQUENCE(COUNTA(A:A)/2,2))
```

answered Feb 21, 2023 by
• 63,420 points

0 votes
1 answer

## How to split columns into two sub columns under their parent column using python in excel

Use str.split: df[['pre', 'post']] = df['Column A'].str.split(r'\s*-->\s*', expand=True) print(df) # Output ...READ MORE

+1 vote
0 answers

0 votes
0 answers

## How to merge two sorted arrays into a sorted array?

this question was asked in interview  public static ...READ MORE

0 votes
1 answer

## How to change two different date format into single date format in excel

With data in A2, in B2 enter: =IF(ISNUMBER(A2),A2,DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2))) and apply your format ...READ MORE

0 votes
0 answers

## MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

0 votes
1 answer

## In excel how do I reference the current row but a specific column?

Put a \$ symbol in front of ...READ MORE

0 votes
1 answer

## Excel function for divide or split number to maximum possible equal parts

The underlying math for this is as ...READ MORE

0 votes
0 answers

## How to create DropDown which have dynamic Validation List

In my data table, the columns "Category" ...READ MORE

0 votes
1 answer

## Excel, How to split cells by comma delimiter into new cells

The Excel manual method: choose Text to Column ...READ MORE

0 votes
1 answer

## Excel: How to merge two columns into one (from different sheets or separated columns)

This equation is completely adjustable. Your two ...READ MORE