I want to shift each row to the right based on the value in the cell in column A. Skip the header row.
If row 2 has a 1 in cell A2, then the entire second row shifts to the right one column.
If row 3 has a 2 in cell A3, then the entire third row shifts to the right 2 columns and so on through all rows on the active sheet.
ChatGPT failed me.
)
Thanks!
If row 2 has a 1 in cell A2, then the entire second row shifts to the right one column.
If row 3 has a 2 in cell A3, then the entire third row shifts to the right 2 columns and so on through all rows on the active sheet.
ChatGPT failed me.

Thanks!