Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: move data from rows and columns to other rows and columns


(!)

kf4fzr's Avatar
kf4fzr kf4fzr is offline
Junior Member with 2 posts.
THREAD STARTER
 
Join Date: Jun 2010
Experience: Intermediate
29-Jun-2010, 08:42 PM #1
Solved: move data from rows and columns to other rows and columns
I have data that repeats hundreds of times. I am trying to put each string of data on 1 line.

f-name(A2) initial(B2) l-name(C2) ID#(D2) DOB(E2) Street(F2) company(G2)
City(F3) company#(G3)
State,Zip(F4)
Home Phone(F5)
Work Phone(F6)
Email(F7)

After the data is moved to one line I would like to delete the lines that previously housed the information. The company# can be deleted. I have never worked with macros. I would appreciate any help given.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
04-Jul-2010, 06:24 AM #2
bump
kf4fzr's Avatar
kf4fzr kf4fzr is offline
Junior Member with 2 posts.
THREAD STARTER
 
Join Date: Jun 2010
Experience: Intermediate
05-Jul-2010, 07:07 PM #3
I need to move the data around so that it is all on one line. From what I find with the "bump" it doesn't do that.
turbodante's Avatar
turbodante turbodante is offline
Senior Member with 744 posts.
 
Join Date: Dec 2008
Location: GMT UK
06-Jul-2010, 03:40 AM #4
Quote:
Originally Posted by kf4fzr View Post
I need to move the data around so that it is all on one line. From what I find with the "bump" it doesn't do that.

lol. Perhaps 'bump' will become one of the touch screen iPad type functions

Welcome to the forum kf4fzr btw.

Is this excel? If so, can you upload a sample before and after workbook so we can see exactly what you require.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
delete, excel 03, macros, move data

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


Similar Threads
Title Thread Starter Forum Replies Last Post
Restore Data from WD Sync External HD kawill Hardware 1 22-Mar-2010 03:00 PM
Copying data from various text boxes to a .txt file tech.jk Software Development 2 15-Nov-2009 05:04 AM
Simple Excel Macro to Copy Row from one Sheet to Another exterminar Business Applications 1 14-Aug-2009 04:27 AM
Need to transfer data from PC-formatted HD to Mac zavulon Hardware 0 28-Feb-2009 10:31 PM
Solved: Data From One Column To Split Into Two Columns...how? shalinid Business Applications 6 02-Jul-2008 06:43 PM

WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑