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

kf4fzr · 29-Jun-2010, 09:42 PM #1

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 · 04-Jul-2010, 07:24 AM #2

bump

kf4fzr · 05-Jul-2010, 08: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 · 06-Jul-2010, 04:40 AM #4

Quote:

Originally Posted by kf4fzr

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.

Similar Threads
Title	Thread Starter	Forum	Replies	Last Post
Restore Data from WD Sync External HD	kawill	Hardware	1	22-Mar-2010 04: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 05: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 07:43 PM

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

Search
Search for:

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

Find the solution to your computer problem!

Find the solution to your
computer problem!