Hello.
I would like to be able to shift cells down so that the values in two columns align. Currently, I am looking at each row and manually insert - shift cells down to line up the values in each column. I have thousands of rows, so I can easily spend half a day or more doing this. Is there a formula or something that will accomplish this? I'll do my best to provide an example below.
Thank you for your time and consideration!
<tbody>
</tbody>
I would like to be able to shift cells down so that the values in two columns align. Currently, I am looking at each row and manually insert - shift cells down to line up the values in each column. I have thousands of rows, so I can easily spend half a day or more doing this. Is there a formula or something that will accomplish this? I'll do my best to provide an example below.
Thank you for your time and consideration!
Data 1 - Original | Data 2 - Original | Data 1 - Adjusted | Data 2 - Adjusted | |
M4262 | M4262 | M4262 | M4262 | |
M4264 | M4263 | inserted automatically | M4263 | |
M4265 | M4266 | M4264 | inserted automatically | |
M4267 | M4268 | M4265 | inserted automatically | |
M4268 | inserted automatically | M4266 | ||
M4267 | inserted automatically | |||
M4268 | M4268 | |||
<tbody>
</tbody>