Pau Lo
asked on
reorder data
is there an easy way in excel, to re-order data. essentially into a single column (A) I need to "merge" two columns (B and C).
I need to copy data from columns B and column C into column A, however they need to be copied in a sequential order, so
A1 needs to be a copy of B1
A2 needs to be a copy of C1
A3 needs to be a copy of B2
A4 needs to be a copy of C2
A5 needs to be a copy of B3
A6 needs to be a copy of C3
etc. is this possible?
I need to copy data from columns B and column C into column A, however they need to be copied in a sequential order, so
A1 needs to be a copy of B1
A2 needs to be a copy of C1
A3 needs to be a copy of B2
A4 needs to be a copy of C2
A5 needs to be a copy of B3
A6 needs to be a copy of C3
etc. is this possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you had a chance to check the proposed solutions ?
gowflow
gowflow
ASKER