LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Copying Data from 1 format to another

I have data in this row type of format:

Name:xxx
Address:xxx
Phone Number:xxx

With about 75 entries like this.
I need to get it into a column type of format:
Name Address Phone Number
x x
x

The name, address, phone number are all similar-they came in a form. Is
there a shortcut to moving the entries to the columns that I want them In?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying data from other worksheet including entire format Bud Excel Discussion (Misc queries) 0 April 15th 09 09:44 PM
Change Date Format to Specific Text Format When Copying [email protected] Excel Discussion (Misc queries) 4 December 23rd 08 03:43 PM
Copying the data in and format of a cell to another cell cyberdude Excel Discussion (Misc queries) 1 January 6th 07 12:22 PM
Copying range format and formulae without data Kevryl Excel Discussion (Misc queries) 1 September 9th 05 01:55 PM
Copying Format Across... Excel Dummy Setting up and Configuration of Excel 1 August 20th 05 07:18 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"