Forum Discussion
Splitting families into individuals excel formatting
can you elaborate? Appreciate the help.
If Power Query is available on your computer you can open the file that is attached to my previous post. Then you can enter data in the blue dynamic table. Then you can click in any cell of the green table, right-click with the mouse and refresh.
- Ok i gave it a shot. The problem is these lists are usually emailed to me with already of over 300 contacts as couples. I just need to split it up
Did you get the expected result? If so it should be possible to copy the 300+ contacts from the other file and paste them into the blue dynamic table. Then you can refresh the green table. In the attached file i've rearranged the layout of the tables. You can enter huge numbers of contacts in the blue table.
i was sent with the name in one row. I split them up with text to columns. I should have included the specific layout in the beginning. I see what you are saying with copy and pasting to your data query file, but my info is going all over the place. this is an example of where I am now. Under family it would have said Accardo John & marlene.
FAMILY NAME Primary Address address 2 City State zip Primary Phone E-Mail Address Accardo John & Marlene 68 elm Cody WY 82414 307-586-0000 email address removed for privacy reasons Adkins Joanne and david 2202 main St Cody WY 82414 307-527-0000 email address removed for privacy reasons Agudo Freddy & mary PO Box main Cody WY 83214 000-000-000 email address removed for privacy reasons Alexander Steven & dennis 1313 Red elm ave. Cody WY 82414 Alvarado Nicole & jamie 29 house rd Henderson NV 89011 307-527-0000