Hi,

It's not clear (at least to me) precisely what you want. I'm guessing, maybe incorrectly that you are looking to shift cells left in some way but that is a guess.
Please clarify and upload a workbook with examples of real data (not just example a,b,c type data). In addition manually add the layout and results you expect to see when the task is finished.