I have a spreadsheet with Year in row 1, and Month in row 2.
I need to combine them into dates before promoting the resulting row into a header row.
The data looks like this:
2017, 2017, 2017,...
Jan , Feb, Mar ,...
I'm trying to get:
Jan 2017, Feb 2017, Mar 2017,...
I've read this but can't find information about relative column references Absolute & Relative References.
Transpose table
Merge first two columns