How do I format my data if it doesn't have header rows?

First, ensure that your titles are listed by column instead of by row. If you have dates as column titles, you will need to switch these to rows. 

To switch row titles to column titles simply:

1. Copy the data you'd like to work with

2. Right click in a new cell and select "Paste Special"

3. In the Paste Special dialog box, click "Transpose"

This is also a helpful tool to reshape data if transposing doesn't work. 

In the end, you want your data to in raw data form and look like this:

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request