Hi... I am struggling to manage the format of my data in order to track the journey of a persons contact with us. Currently this data is presented in a series of rows but i'd like to see this in a more linear way... is anybody able to help? I have attached an example of how it may look.... In addition, within the data the system we use also generates duplicate rows where a team is on a row and a worker and team. Where a team and worker are shown I want to keep that row only and lose the row with team only... If anybody can help i would be so grateful as i am pulling my hair out at the moment!!! Thanks in advance....
Ohhhh wow!!! that is amazing - i was totally looking down the wrong route of multi rows.... this is going to help me in so many areas of my data ..... thanks so much...
