ExcelBanter - Data in one column

Insert a new column A and put this formula in A1:

=B1&C1&D1&E1&F1&G1&H1&I1&J1&K1

and copy down to A10. You might like to separate the fields (eg with
the pipe character), so you could have:

=B1&"|"&C1&"|"&D1&"|"&E1&"|"&F1&"|"&G1&"|"&H1&"|"& I1&"|"&J1&"|"&K1

If you have numeric data in some of the fields you might like to use
the TEXT function to control how many characters the number is
represented as.

Highlight A1:A10, click <copy, then Edit | Paste Special | Values
(check) | OK then <Enter in order to fix the values, then you can
delete your original data in B1:K10.

Hope this helps.

Pete

On Oct 4, 8:20 am, KCG wrote:
Hello friends,

I have my data in A1:J10.

How can I transpose all my data to fit into Column A?

Thanx for your help.
--
KCG