How to split column into two

0 votes

I have a dataset which looks like this:

enter image description here

And I want to convert it into something like this:

enter image description here

How can I achieve it in excel?

Feb 21 in Others by Kithuzzz
• 34,760 points
65 views

1 answer to this question.

0 votes

Using WRAPSROWS()

enter image description here


• 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 by narikkadan
• 59,740 points

Related Questions In Others

+1 vote
0 answers

How to split a number with coma betweeen two colunms

Jul 3, 2019 in Others by anonymous
268 views
0 votes
0 answers

How to merge two sorted arrays into a sorted array?

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

Nov 17, 2022 in Others by Ashwini
• 3,750 points
119 views
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

answered Dec 24, 2022 in Others by narikkadan
• 59,740 points
86 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8 in Others by narikkadan
• 59,740 points
340 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

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

Feb 18, 2022 in Others by Edureka
• 13,630 points
124 views
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

answered Oct 15, 2022 in Others by narikkadan
• 59,740 points
386 views
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

answered Oct 17, 2022 in Others by narikkadan
• 59,740 points
495 views
0 votes
0 answers

How to create DropDown which have dynamic Validation List

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

Oct 31, 2022 in Others by Kithuzzz
• 34,760 points
206 views
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

answered Oct 3, 2022 in Others by narikkadan
• 59,740 points
158 views
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

answered Oct 7, 2022 in Others by narikkadan
• 59,740 points
223 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP