This is a strange problem-I am trying to export some table info into Act
database. I have a table of contacts for each company. Each company can have
up to 5 contacts. I need to export this data (640 records) so that the
result is one long row of information, instead of multiple rows of contacts
per company.
For example- as it is now, by table info looks like this-
Company Contact Email Phone
ABC Joe joe@joe.com 555-555-5555
ABC Jill Jill@jill.com 5555555555
ABC BOB bob@email.com 5555555555
XYZ TIM tim@yo.com 5555555555
XYZ TOM sup@ohboy.net 5556668522
And I need it to export in to Excel as
Company Contact1 Email1 Phone1 Contact2 Email2 Phone2 Contact3 Email3
Phone3
ABC Joe joe@joe.com 555-555-5555 Jill Jill@jill.com 5555555555
BOB bob@email.com 5555555555
XYZ TIM tim@yo.com 5555555555 TOM sup@ohboy.net 5556668522
How can I do this?
Thanks
database. I have a table of contacts for each company. Each company can have
up to 5 contacts. I need to export this data (640 records) so that the
result is one long row of information, instead of multiple rows of contacts
per company.
For example- as it is now, by table info looks like this-
Company Contact Email Phone
ABC Joe joe@joe.com 555-555-5555
ABC Jill Jill@jill.com 5555555555
ABC BOB bob@email.com 5555555555
XYZ TIM tim@yo.com 5555555555
XYZ TOM sup@ohboy.net 5556668522
And I need it to export in to Excel as
Company Contact1 Email1 Phone1 Contact2 Email2 Phone2 Contact3 Email3
Phone3
ABC Joe joe@joe.com 555-555-5555 Jill Jill@jill.com 5555555555
BOB bob@email.com 5555555555
XYZ TIM tim@yo.com 5555555555 TOM sup@ohboy.net 5556668522
How can I do this?
Thanks