Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default export from cardscan expanded rows

We are trying to do a mail merge from excel. We exported several hundred
contacts from CardScan into a worksheet. Some of the contacts with several
lines of information in a particular column were split into several rows.
Other contacts correctly had one contact in one row. We would like to somehow
merge the information such that there is only one row. Any help is
appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 145
Default export from cardscan expanded rows

Your service provider has to see the sample data file and your preferred
output layout please

--
Regards

"Stacey" wrote in message
...
We are trying to do a mail merge from excel. We exported several hundred
contacts from CardScan into a worksheet. Some of the contacts with several
lines of information in a particular column were split into several rows.
Other contacts correctly had one contact in one row. We would like to

somehow
merge the information such that there is only one row. Any help is
appreciated.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default export from cardscan expanded rows

I'm not sure of how to post a sample file to show how to clean it up?
Cutting and pasting won't show a sample Excel file. Please let me know how
to do this?


"PY & Associates" wrote:

Your service provider has to see the sample data file and your preferred
output layout please

--
Regards

"Stacey" wrote in message
...
We are trying to do a mail merge from excel. We exported several hundred
contacts from CardScan into a worksheet. Some of the contacts with several
lines of information in a particular column were split into several rows.
Other contacts correctly had one contact in one row. We would like to

somehow
merge the information such that there is only one row. Any help is
appreciated.




Reply
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
Getting all rows of data that have a value in a particular column Rikki-Handgards Excel Discussion (Misc queries) 30 December 10th 07 12:29 PM
Macro needed for inserting blank rows sunslight Excel Worksheet Functions 2 January 12th 07 05:58 PM
Copying multiple rows to other worksheets (but amount of rows varies) - How? David Smithz Excel Discussion (Misc queries) 1 June 18th 06 04:31 PM
Custom export with multiple rows for each row in original spreadsh pfwebadmin Excel Worksheet Functions 0 October 31st 05 09:37 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM


All times are GMT +1. The time now is 11:40 AM.

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"