Skip toΒ content

Excel - INHERITEDDATA F Bossans 2022-10-15 STACKED - Excel - 3 November 2022

2 mins

View Comments and Reply

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

More than 21 million people across 200,000 companies choose Loom

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 Goodell

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 Quick

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 Flanagan

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 Okuinev

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 Goodell

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 Quick

Tyson QuickCEO, Postclick