Excel - INHERITEDDATA F Bossans 2022-10-15 STACKED - Excel - 3 November 2022
2 mins
Transcript
Show Transcript
Hi team. Good morning. I just need your help on how we can be more efficient with the process that we have in inherited data.
So this is the file that we have downloaded and before we import it, we need to format the file first and if possible, that you can help us on how we can be able to have one property owner and all of its information in one row, for example.
But you can see here there are multiple property owners in just in more than one row. It's because of its phone numbers and email that was separately fill in in three columns.
So we only have one, two, three columns for phone numbers and three columns for email interest as well. So if it's more than three phone numbers it will be added on the next row like this.
So what will happen is if we import it in the domain, in the I by domains, the only numbers that will be added is just the on the first row.
So the other numbers here that should be included upon import is not showing sometimes in the ibin domain. So if it's possible we can have 19 Toson conception, Aon Francisco Ruiz in just one row right here.
So we can be able to upload all the necessary information like the phone numbers in email, in just one import like this.
Let me know if you need anything else and I'll be happy to provide. Thank you.
Transcript
Show Transcript
Hi team. Good morning. I just need your help on how we can be more efficient with the process that we have in inherited data.
So this is the file that we have downloaded and before we import it, we need to format the file first and if possible, that you can help us on how we can be able to have one property owner and all of its information in one row, for example.
But you can see here there are multiple property owners in just in more than one row. It's because of its phone numbers and email that was separately fill in in three columns.
So we only have one, two, three columns for phone numbers and three columns for email interest as well. So if it's more than three phone numbers it will be added on the next row like this.
So what will happen is if we import it in the domain, in the I by domains, the only numbers that will be added is just the on the first row.
So the other numbers here that should be included upon import is not showing sometimes in the ibin domain. So if it's possible we can have 19 Toson conception, Aon Francisco Ruiz in just one row right here.
So we can be able to upload all the necessary information like the phone numbers in email, in just one import like this.
Let me know if you need anything else and I'll be happy to provide. Thank you.
More than 25 million people across 400,000 companies choose Loom
For Mac, Windows, iOS, and Android
My teammates and I love using Loom! It has saved us hundreds of hours by creating informative video tutorials instead of long emails or 1-on-1 trainings with customers.
Erica GoodellCustomer Success, Pearson
Loom creates an ongoing visual and audible experience across our business and enables our employees to feel part of a unified culture and company.
Tyson QuickCEO, Postclick
My new daily email habit. Begin writing an email. Get to the second paragraph and think 'what a time suck.' Record a Loom instead. Feel like 😎.
Kieran FlanaganVP of Marketing, HubSpot
Loom amplifies my communication with the team like nothing else has. It's a communication tool that should be in every executive's toolbox.
David OkuinevCo-CEO, Typeform
My teammates and I love using Loom! It has saved us hundreds of hours by creating informative video tutorials instead of long emails or 1-on-1 trainings with customers.
Erica GoodellCustomer Success, Pearson
Loom creates an ongoing visual and audible experience across our business and enables our employees to feel part of a unified culture and company.
Tyson QuickCEO, Postclick