Data in one column

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.
 
P

Pete_UK

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
 

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
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Transpose several columns to one long column 1
Past Special- Transpose Function? 7
copying same cell diff worksheets to new sheet 1
How to transpose data (Row to column) without losing the cell link 3

Top