Eliminating sporadic duplicates and shifting data over

[PatrickHudson]

My data randomly has two charge codes scattered throughout a couple thousand lines. This offsets these rows by one column, I'd like to delete the duplicate Charge Code and have the data on those rows shift to the left to properly align. The screenshot shows an example of this on the second row. I've searched around for an answer to this, however I keep coming to solutions that address entire dupliate rows instead of just a duplicate column value or the trouble column is not mixed with correct data. Any advice in the right direction would be greatly appreciated. (First time poster) 

[v-stephen-msft · Accepted solution]

Hi @PatrickHudson ,

Since you have a partial row with two columns of Charge Code, you will have an extra column with null and the value of the previous column.

For example, the sample data is as follows.

You can duplicate one table, the primary table is table A, and the other is table B. Table A retains values and Table B retains null.

Then the columns of Table A and Table B are adjusted separately, and finally appended.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.