Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data in one column
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column chart wit more than one column in a data point | Charts and Charting in Excel | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
counting data in one column and match with data in another column | Excel Discussion (Misc queries) | |||
If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions |