Data in one column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding to a formula thru out a worksheet 2
How to combine multiple columns into different cells in one column 4
Data search problem 2
Past Special- Transpose Function? 7
Transpose several columns to one long column 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
copying same cell diff worksheets to new sheet 1
fill series of multiple rows and columns 4

Back
Top