I have a spreadsheet with two header rows. I want to generate the "full column name" as shown on row 3.
A | B | C | D | E | F |
------------------------------------------------------------
1 | W | Y |
2 | 2 | 4 | 3 | 4 | 10 | 12 |
3 | W-2 | W-4 | Y-3 | Y-4 | Y-10 | Y-12 |
I tried a simple concatenate and filled across, but only the first cell of a merged range contains the value. In other words, cells B1, D1, E1, and F1 are blank.
How can I generate the full column name for each column?