Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I have a column of data and I'd like to transpose it to go across.
I have a column of data going down that I'd like to transpose to go across
the page so that I can add this info to data going across the page. I mean for example, I have data Jan, Feb, Mar, going down the page and I'd like them to be going across like 1st Month, 2nd Month, 3rd Month etc., but they are going from top to bottom and I want them to go from right to left. I tried the Transpose function, however, when I went to click on the arrow to the Right of PASTE, there was no arrow. Any suggestions?? John |
#2
|
|||
|
|||
Copy the data, right click in Cell where you want to begin paste, select
Paste Special and check Transpose box. Regards Rowan "JohnTheMan59" wrote: I have a column of data going down that I'd like to transpose to go across the page so that I can add this info to data going across the page. I mean for example, I have data Jan, Feb, Mar, going down the page and I'd like them to be going across like 1st Month, 2nd Month, 3rd Month etc., but they are going from top to bottom and I want them to go from right to left. I tried the Transpose function, however, when I went to click on the arrow to the Right of PASTE, there was no arrow. Any suggestions?? John |
#3
|
|||
|
|||
Hi all,
I'm looking for exactly the same answer? Please help us??? Thanks Neil |
#4
|
|||
|
|||
You can use this sequence:
1) select your data range 2) Edit = Copy 3) select the cell from which you want to trnspose the data 4) Edit = PasteSpecial and select the option Transpose Hoping to be helpful Franz "neilcarden" ha scritto nel messaggio ... Hi all, I'm looking for exactly the same answer? Please help us??? Thanks Neil -- neilcarden |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
How do I transpose an Excel 2003 column of data? | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |