Shift Elements of 2D VBA Array

Question

All -

I'm wondering if there's an efficient way to "shift" elements of a 2-dimensional array. Effectively, what I have is triangular data, saved in a VBA array (n x m, where n <= m):

      0 1 2 3 4 5
  ----------------
  0 | A B C D E F
  1 | G H I J
  2 | K L

I'd like to "restructure" this array to:

      0 1 2 3 4 5
  ----------------
  0 | A B C D E F
  1 |     G H I J
  2 |         K L

The blank values in the array are actually empty strings (""). I'd imagine there's some looping that I could do to perform this with some compute cost, but I'm wondering if there's an efficient approach for subset "shifting" within VBA...

Answer 1

等待大神解答