I have two columns with many rows.
In the left column, load ratings for tires. In the right column, the speed ratings for those tires.
I need to copy this info into another spreadsheet, but for the client's convenience it needs to be one column.
Since I have well over four-hundred entries, I was hoping there was an easier way to merge these cells so I can just copy/paste into the new spreadsheet instead of typing it out manually.
To clarify, the left column contains integers and the right column contains letters, can I consolidate the data into one column? (Example: 113 and S --> 113S)
View best response
@CaffeineKing , in next column you may use formula like
=A1 & B1
drag it down till end of you range (or select till end of the range and Ctrl+D). Copy that column and Paste as values into new sheet.