How can I achieve this in excel:
I have a very long list that I want to do the same on that list. Is there any quick way?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityIn column A is your list then in B1 put the formula and drag it down.
=INDEX(A:A,(ROW(A1)-0.5)*2)
In C1 put the below and drag it down
=INDEX(A:A,(ROW(A2)-1)*2)
Your list will get populated as desired.