M
Melissa
I have a one-column list with similar types of row data, that I would like to
use to create a mulit-column spreadsheet. For example, the list currently
looks like this:
Example A
text
text
text
Example B
text
text
text
Every row is currently in column A. What I would like to do, without having
to copy and paste (I have several hundred rows of text) is to have the data
look like:
Example A Text Text Text
Example B Text Text Text
I have looked at functions such as concatenate and Pivot tables but they
don't seem to do what I need to do.
I would appreciate any help with this.
Melissa
Queensland, Australia
use to create a mulit-column spreadsheet. For example, the list currently
looks like this:
Example A
text
text
text
Example B
text
text
text
Every row is currently in column A. What I would like to do, without having
to copy and paste (I have several hundred rows of text) is to have the data
look like:
Example A Text Text Text
Example B Text Text Text
I have looked at functions such as concatenate and Pivot tables but they
don't seem to do what I need to do.
I would appreciate any help with this.
Melissa
Queensland, Australia