Hi Macropod,

Thanks for the formula - so what is the solution to solving the problem where it shows the same 'No tenant' throughout the entire column as I dont understand what you mean that the data is string data.


You see the intended purpose for the data is to create a pivot table, so all the data comes from my sql database which makes it difficult to manipulate too much out of their given sheets.


Thanks.