| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 42819 | 2004-02-23 08:17:00 | Paste Vertical Data Into Excel | Troutfisher1 (5302) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 217614 | 2004-02-23 08:17:00 | Is there any easy way to paste vertical data into a horizontal format in excel?, I'm trying to convert our internal database into excel, this has 3 lines of text ie Company Name,Address, Location, when copied & pasted it pastes into 3 vertical cells any solutions, Thanks for any help cheers Steve | Troutfisher1 (5302) | ||
| 217615 | 2004-02-23 08:23:00 | if its already in vertical form... select it... then select (verticly) the cells where you want to past the data... then ctrl +V if this is what you mean.... |
00falcon (3801) | ||
| 217616 | 2004-02-23 08:54:00 | Thanks for that, this I can do but somehow I need to seperate this data into columns & there's nothing to use to sort the data the data is in this format: Joe Bloggs Computer Expert 69 Charge Alot lane Christchurch when you copy & paste this it pastes vertically in seperate cells Cheers |
Troutfisher1 (5302) | ||
| 217617 | 2004-02-23 09:00:00 | Instead of just "paste" use paste special - values - transpose |
godfather (25) | ||
| 217618 | 2004-02-23 20:20:00 | Awesome, Thanks Godfather, Cheers Steve |
Troutfisher1 (5302) | ||
| 1 | |||||