Add cell from other column into a column by cell
Column 6 and Column 11, I want first cell in column 11 to be mapped inbetween of the 1st and 2nd cell in column 6, then second cell in column 11 to be mapped inbetween of the 2nd and 3rd cell in column 6, and so on. Is there any idea how to do this?
Process would look like this
Step one : Insert new rows inbetween rows in column 6 : row 1 and 2, and row 2 and 3
Step 2 : drag value of cell 1 and 2 from column 11 in to the respective cell in column 6
This would be manual, but is there an automatic way by using formula on excel to address this issue?
Please help, thank you.
Also, if you need the excel file do tell.
Column 6 and Column 11, I want first cell in column 11 to be mapped inbetween of the 1st and 2nd cell in column 6, then second cell in column 11 to be mapped inbetween of the 2nd and 3rd cell in column 6, and so on. Is there any idea how to do this?Process would look like this Step one : Insert new rows inbetween rows in column 6 : row 1 and 2, and row 2 and 3 Step 2 : drag value of cell 1 and 2 from column 11 in to the respective cell in column 6 This would be manual, but is there an automatic way by using formula on excel to address this issue?Please help, thank you. Also, if you need the excel file do tell. Read More