transposing data

[kate1234]

I am looking to make a single list of data that I currently have in many different rows, all into one column. I tried to copy and transpose the data but it ended up putting each row of information into its own column. Is there a way to take several rows of data into one column?

[ben_hensel]

Concatenate all the date into one helper row and then transpose that???

I mean, if you have a {50 x 2} matrix, do you you want it to output into a {1 x 100} matrix or a {1 x 50} matrix?

[kate1234]

I have about 20 rows and 40 columns of keywords, I want to put all of the keywords in one column. How would I create a helper row?

[phillikr]

So you're saying you have something like this:

apple orange strawberry
grape lemon melon
banana lime cucumber


And you want it to be like this:

apple
grape
banana
orange
lemon
lime
strawberry
melon
cucumber


Does the order matter?

If you're talking about a 20x40 grid, cut-and-paste is really the simplest way to go.

Or, you could copy one row at a time, then paste-special-transpose to your destination area, changing your starting point each time.

Not sure the helper row will cut it for you since you sound like you want to keep all the cells' values separate.

[kate1234]

Yep, that is exactly what I am looking to do. The order doesn't matter, is there a way to cut and paste them all into one row? Or do I have to copy then paste transpose each line?

[phillikr]

This is a 2-page picture of what I'm imagining I'd do in your situation:

1.png

2.png

If this doesn't apply, please upload images or a sample file.. :-)

[phillikr]

Ahh. That's what I was looking for... insert the pdf. In case this helps.

transposing data.pdf