chrisscotty
Board Regular
- Joined
- Jul 9, 2002
- Messages
- 87
Hello All,
I just recently switched to Excel 2007 and am not that familiar with the program.
I have a question that has 3 components.
I have alot of data in Column A that has many blank cells.
I performed several searches and have still not been able to remove them.
This particular method worked if I was selecting a small amount of data
http://www.tech-recipes.com/rx/2189/excel_2007_eliminate_blank_rows/
Yet when I use with the entire list I get the error "selection is too large".
What I basically want to do is take the data that I have gathered and transpose it so I can save as a csv file and import in to my contact manager.
The data looks like this:
NEXT ENTRY
" "
Mr. Rene Reynolds
Chapters: Philadelphia
Position/Title: Machinist
Company: ABC Limited
71 Maybrook Drive
Philadelphia, PA 19118, USA
Bus. Telephone: (215) 298-8108x265
Fax: (215) 298-3545
E-mail: rene.reynolds@abc.com
NEXT ENTRY
" "
Ms Carol Jones
Chapters: Ottawa
Position/Title: Benefits Administrator
28 Reeds Road
North Bay, ON K9J 0K4, CANADA
E-mail: c_jones@yahoo.com
NEXT ENTRY
Mr Billl Jones
Chapters: Binghampton
NEXT ENTRY
----------
So each name after "Next ENTRY" is a new entry and I want the data transposed
Now, all this is consistent as far as the order..name, chapter, postion etc.
The thing is not all names have all the information some just have the name and phone, name and chapter etc etc.
Mr. Rene Reynolds
Chapters: Philadelphia
Position/Title: Machinist
Company: ABC Limited
71 Maybrook Drive
Philadelphia, PA 19118, USA
Bus. Telephone: (215) 298-8108x265
Fax: (215) 298-3545
E-mail: rene.reynolds@abc.com
So..first I want to get rid of all the empty cells and move up and then transpose the data and have it correspond to each entry and if it missing a fied it just skips over.
Oh and one more thing =-)
There appears a little question mark that I can not delete. Some of them appear before the name and some of them appear under NEXT ENTRY and appear as " " when I paste data from excel in to a txt file.
Any help would be greatly appreciated.
I just recently switched to Excel 2007 and am not that familiar with the program.
I have a question that has 3 components.
I have alot of data in Column A that has many blank cells.
I performed several searches and have still not been able to remove them.
This particular method worked if I was selecting a small amount of data
http://www.tech-recipes.com/rx/2189/excel_2007_eliminate_blank_rows/
Yet when I use with the entire list I get the error "selection is too large".
What I basically want to do is take the data that I have gathered and transpose it so I can save as a csv file and import in to my contact manager.
The data looks like this:
NEXT ENTRY
" "
Mr. Rene Reynolds
Chapters: Philadelphia
Position/Title: Machinist
Company: ABC Limited
71 Maybrook Drive
Philadelphia, PA 19118, USA
Bus. Telephone: (215) 298-8108x265
Fax: (215) 298-3545
E-mail: rene.reynolds@abc.com
NEXT ENTRY
" "
Ms Carol Jones
Chapters: Ottawa
Position/Title: Benefits Administrator
28 Reeds Road
North Bay, ON K9J 0K4, CANADA
E-mail: c_jones@yahoo.com
NEXT ENTRY
Mr Billl Jones
Chapters: Binghampton
NEXT ENTRY
----------
So each name after "Next ENTRY" is a new entry and I want the data transposed
Now, all this is consistent as far as the order..name, chapter, postion etc.
The thing is not all names have all the information some just have the name and phone, name and chapter etc etc.
Mr. Rene Reynolds
Chapters: Philadelphia
Position/Title: Machinist
Company: ABC Limited
71 Maybrook Drive
Philadelphia, PA 19118, USA
Bus. Telephone: (215) 298-8108x265
Fax: (215) 298-3545
E-mail: rene.reynolds@abc.com
So..first I want to get rid of all the empty cells and move up and then transpose the data and have it correspond to each entry and if it missing a fied it just skips over.
Oh and one more thing =-)
There appears a little question mark that I can not delete. Some of them appear before the name and some of them appear under NEXT ENTRY and appear as " " when I paste data from excel in to a txt file.
Any help would be greatly appreciated.