We have a client that provided us with a text file that we exported into
Excel. Rather than have the entire record in one row, they have the
record in 4 rows. Someone suggested that there is a "Merge" function in
Excel that would allow us to move the data to the same row but we are
coming up empty in trying to find out how that is done.Anybody familiar
with that function or any other function that you can suggest to
resolve this dilemma?
1 John Smith street city state ZIP award 1
2 John Smith street city state ZIP award 2
3 John Smith street city state ZIP award 3
4 John Smith street city state ZIP award 4
5 Bill Jones street2 city2 state2 ZIP2 award 1
6 Bill Jones street2 city2 state2 ZIP2 award 2
7 Bill Jones street2 city2 state2 ZIP2 award 3
8 Bill Jones street2 city2 state2 ZIP2 award 4
What we need for our merge to work is:
1 John Smith street city state ZIP award 1 award 2 award 3
award 4
2 Bill Jones street2 city2 state2 ZIP2 award 1 award 2 award 3
award 4
Any suggestions or directions would be appreciated.
--
David L. Young
Spectrum Printing LLC
4651 S Butterfield Dr
Suite 161
Tucson, AZ 85714
Phone 520 571 1114
Fax 520 571 1395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Calling all FP Web Users!
Do you have a question or lots of knowledge to share about FusionPro Web?
If so, join our Printable Web to Print Users' Forum today!
Send email to [EMAIL PROTECTED] to find out how!
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--