In this scenario, the requirement is to segregate data present in cells at odd and even places and put them in them separate columns.
Original Data Representation :
Desired Data format :
The formula used to obtain desired is as follows :
In this example the original data was in A1 Column and we have placed it in column E and F
For Odd Cell : =INDEX(A:A,1+(2*ROW()-2))
For Even Cell : =INDEX(A:A,1+(2*ROW()-1))
Original Data Representation :
Desired Data format :
The formula used to obtain desired is as follows :
In this example the original data was in A1 Column and we have placed it in column E and F
For Odd Cell : =INDEX(A:A,1+(2*ROW()-2))
For Even Cell : =INDEX(A:A,1+(2*ROW()-1))
