1
votes

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.

1

1 Answers

3
votes
  1. Transpose table

  2. Merge first two columns

  3. Transpose again

Link