View Single Post
  #1   Report Post  
mj44
 
Posts: n/a
Default Concatenate multiple rows and columns into 1 cell

I have a spreadsheet using 3 columns and n number of rows worth of data. I
am trying to create one long string of this data by concatenating in the
following order:

A1,B1,C1,A2,B2,C2,A3,B3,C3, etc.

The only way I know how to do a large range is to individually click on each
cell and that will take a very long time.

Is there an easy way to concatenate a range such as (A1:C500)?

Thank you.