I have been pulling my hair to get this seemingly doable problem solved. The solution should work on Excel 2007 or later. I'd like to create a single column with header text and blank cells based upon two columns as follows:
X A B 1 1 Jack 2 1 Steve 3 1 Mary 4 2 Salima 5 2 Michael 6 2 Roberto 7 2 Stella 8 3 Jean 9 3 Penelope
The resulting column would be formatted as follows:
X C 1 Section 1 2 3 Jack 4 Steve 5 Mary 6 7 Section 2 8 9 Salima 10 Michael 11 Roberto 12 Stella 13 14 Section 3 15 16 Jean 17 Penelope
Ideally I'd like to create an array formula that can be created in the first cell of the column then copied down the column. I cannot use a macro for this function as the client only can accept non-macro-based xlsx sheets. I can use helper columns if necessary. Thanks.
Bookmarks