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