How to automate shifting of cells to the left

[Vadrosaul]

Hello,

I have a unique problem in data I imported into Excel. On some of the fields, the columns shifted information to the right cells, but some were not shifted. Thus, I need logic that shifts SOME of the rows to the left by 1 cell.

The condition is this: If the column to the right has text data in it that is structured a certain way (e.g. "XTH1"), do not shift all columns to the left. Otherwise, if the column to the right has text data in it that is structured any different way (e.g. "on my way home"), shift all columns to the left. When I say shift, I mean Delete a blank column and have every column to the right of it shift over to the left by 1.

[PaulSP8]

This sounds doable but we're probably going to need to see the Workbook for it.

Can you upload a copy with some sample data? It doesn't need to be *actual* data - Just representative of it so we can see Column headers and the like, include as many rows as you see fit to give a good idea of the different data in them.

If you could include an expected output of the data as well that'd be good.

To do this click on "Go Advanced" and locate select "Manage attachments" and upload from there - Any other option you might see to upload doesn't work

Thanks