|
Listss
How can I put the following information into an excel spreadsheet with the
information going across the sheet other than copy, paste special, transpose with each one Maurine Allen 7475 Skillman St #D-103 Dallas TX USA 75231 Achieva International (214) 823-9500 (214) 823-9514 Meeting Management Professional Melissa Allen 3220 Coolidge Highway Berkley MI USA 48072 Mission Point Resort 248-291-8871 248-542-3868 Supplier Meeting Professional Micah Allen 105 E. Pascagoula St., Suite 2 Jackson MS USA 39207 Jackson Convention Complex/SMG 601-383-4454 Supplier Meeting Professional Micki Allen 345 Renfrew Dr #101 Markham ON CAN L3R 9S9 MARAC Enterprises (905) 474-9118 (905) 474-1968 Corporate Meeting Professional |
Listss
This looks like it would be very difficult to "flatten" your data.
There doesn't seem to be any indicator when the group starts--and the number of rows in each group isn't constant. And that could make putting fields into the correct column difficult, too. Dendy wrote: How can I put the following information into an excel spreadsheet with the information going across the sheet other than copy, paste special, transpose with each one Maurine Allen 7475 Skillman St #D-103 Dallas TX USA 75231 Achieva International (214) 823-9500 (214) 823-9514 Meeting Management Professional Melissa Allen 3220 Coolidge Highway Berkley MI USA 48072 Mission Point Resort 248-291-8871 248-542-3868 Supplier Meeting Professional Micah Allen 105 E. Pascagoula St., Suite 2 Jackson MS USA 39207 Jackson Convention Complex/SMG 601-383-4454 Supplier Meeting Professional Micki Allen 345 Renfrew Dr #101 Markham ON CAN L3R 9S9 MARAC Enterprises (905) 474-9118 (905) 474-1968 Corporate Meeting Professional -- Dave Peterson |
Listss
One of your pieces of data is "missing" a phone number... how many phone
number columns will there be (one with both phone numbers in a single cell, two with the missing phone number shown as an empty cell in the second phone number column, three in case there is ever a third phone number, something else)? Can any of the other data ever be missing? If so, will there **always** be an email address? Rick "Dendy" wrote in message ... How can I put the following information into an excel spreadsheet with the information going across the sheet other than copy, paste special, transpose with each one Maurine Allen 7475 Skillman St #D-103 Dallas TX USA 75231 Achieva International (214) 823-9500 (214) 823-9514 Meeting Management Professional Melissa Allen 3220 Coolidge Highway Berkley MI USA 48072 Mission Point Resort 248-291-8871 248-542-3868 Supplier Meeting Professional Micah Allen 105 E. Pascagoula St., Suite 2 Jackson MS USA 39207 Jackson Convention Complex/SMG 601-383-4454 Supplier Meeting Professional Micki Allen 345 Renfrew Dr #101 Markham ON CAN L3R 9S9 MARAC Enterprises (905) 474-9118 (905) 474-1968 Corporate Meeting Professional |
Listss
I under stand that the columns will not be consistant but I will have
something better to work with even if I have to manually clean it up. Linda "Dave Peterson" wrote: This looks like it would be very difficult to "flatten" your data. There doesn't seem to be any indicator when the group starts--and the number of rows in each group isn't constant. And that could make putting fields into the correct column difficult, too. Dendy wrote: How can I put the following information into an excel spreadsheet with the information going across the sheet other than copy, paste special, transpose with each one Maurine Allen 7475 Skillman St #D-103 Dallas TX USA 75231 Achieva International (214) 823-9500 (214) 823-9514 Meeting Management Professional Melissa Allen 3220 Coolidge Highway Berkley MI USA 48072 Mission Point Resort 248-291-8871 248-542-3868 Supplier Meeting Professional Micah Allen 105 E. Pascagoula St., Suite 2 Jackson MS USA 39207 Jackson Convention Complex/SMG 601-383-4454 Supplier Meeting Professional Micki Allen 345 Renfrew Dr #101 Markham ON CAN L3R 9S9 MARAC Enterprises (905) 474-9118 (905) 474-1968 Corporate Meeting Professional -- Dave Peterson |
Listss
How can a program tell when one record/group ends and the new one starts?
Is the first row of a group bolded/indented/marked in some way? Dendy wrote: I under stand that the columns will not be consistant but I will have something better to work with even if I have to manually clean it up. Linda "Dave Peterson" wrote: This looks like it would be very difficult to "flatten" your data. There doesn't seem to be any indicator when the group starts--and the number of rows in each group isn't constant. And that could make putting fields into the correct column difficult, too. Dendy wrote: How can I put the following information into an excel spreadsheet with the information going across the sheet other than copy, paste special, transpose with each one Maurine Allen 7475 Skillman St #D-103 Dallas TX USA 75231 Achieva International (214) 823-9500 (214) 823-9514 Meeting Management Professional Melissa Allen 3220 Coolidge Highway Berkley MI USA 48072 Mission Point Resort 248-291-8871 248-542-3868 Supplier Meeting Professional Micah Allen 105 E. Pascagoula St., Suite 2 Jackson MS USA 39207 Jackson Convention Complex/SMG 601-383-4454 Supplier Meeting Professional Micki Allen 345 Renfrew Dr #101 Markham ON CAN L3R 9S9 MARAC Enterprises (905) 474-9118 (905) 474-1968 Corporate Meeting Professional -- Dave Peterson -- Dave Peterson |
Listss
In addition to my other questions, I have this one too... where is this list
at right now... in a text file or on a worksheet? Rick "Rick Rothstein (MVP - VB)" wrote in message ... One of your pieces of data is "missing" a phone number... how many phone number columns will there be (one with both phone numbers in a single cell, two with the missing phone number shown as an empty cell in the second phone number column, three in case there is ever a third phone number, something else)? Can any of the other data ever be missing? If so, will there **always** be an email address? Rick "Dendy" wrote in message ... How can I put the following information into an excel spreadsheet with the information going across the sheet other than copy, paste special, transpose with each one Maurine Allen 7475 Skillman St #D-103 Dallas TX USA 75231 Achieva International (214) 823-9500 (214) 823-9514 Meeting Management Professional Melissa Allen 3220 Coolidge Highway Berkley MI USA 48072 Mission Point Resort 248-291-8871 248-542-3868 Supplier Meeting Professional Micah Allen 105 E. Pascagoula St., Suite 2 Jackson MS USA 39207 Jackson Convention Complex/SMG 601-383-4454 Supplier Meeting Professional Micki Allen 345 Renfrew Dr #101 Markham ON CAN L3R 9S9 MARAC Enterprises (905) 474-9118 (905) 474-1968 Corporate Meeting Professional |
| All times are GMT +1. The time now is 07:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com