hmm, didn't think this thread was quite as dead as it was in 2022. i have a question. here's the data i need to manipulate:
the top table is the output. the cells highlighted in yellow will always be blank. the data cells (for which there are 10 in row 1, 9 in row 2 etc) will usually be completed, but not necessarily. i need a macro to convert to the bottom format. the number of rows/columns of months will be the same, but the actual count of them will differ. so basically i need something that will:
- count the number of rows we need to run a loop from (i.e. look for the last cell in column A and remove one), call that variable x
- then for n = 1 to x, delete n-1 cells from row (2+n-1) starting in column b, shifting left
it's been ages since i've used vba, i forget most of the syntax and was never much good at dynamic ranges anyway, tia