Hi,
I´m working for a short-term rental company and we want to perform some deep analysis for each property we are managing. The issue we have is that we get our date from our PMS (third party application) in some kind of block or “calendar format” for where the property name is embedded in the same block. I´ve seen a few videos from Melissa, which are great, and found some very useful tips, but it seems that nothing really doesn´t fit my needs…or at least I just can´t get my head around this.
What I need is to “extract” somehow the property name from the block and create a separate column for it in order to be able to filter later on the property name.
I´ll leave you with a screenshot of how data actually looks like. Thank you for your help!
@Harsh I was here studying your file to see how you solve the problem and it is very good, so I have more than one way to solve the same problem, Thanks.
In case of any doubt please do not hesitate to contact.
Hi @daniel.k, did the response provided by the contributors help you solve your query? If not, how far did you get, and what kind of help you need further? If yes, kindly mark the thread as solved. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. Thanks!
Thank you very much for looking into this. I´ve downloaded the file you prepared and could see how you archived this.
It´s been very helpful! Appreciate your time and effort!
Thank you!! Wish you a great week!
I finally had the time to look on your solution. Thank you very much!! Want you know you that you hurt my ego! (“I solved that in a super simple way”…) hahahaa! Sometimes, when you are staring at something so much you can´t see it anymore. Appreciate your time and effort! Great solution!
have a great week!!
