Hi guys,
Please see below, I really hope you could help me. I would like to extract data from column A and B as below, so that it looks like on the right in column AA BB.
In general I want to extract data without 0 next t the consultant name. And I need to do it with formula, so that it will automatically extract data in the way i want when data on the left will change as I want to use it in my dynamic chart.
Any help much appreciated.
Hope everything is clear if not please let me know i will give more details.
Regards Luke
<tbody>
</tbody>
Please see below, I really hope you could help me. I would like to extract data from column A and B as below, so that it looks like on the right in column AA BB.
In general I want to extract data without 0 next t the consultant name. And I need to do it with formula, so that it will automatically extract data in the way i want when data on the left will change as I want to use it in my dynamic chart.
Any help much appreciated.
Hope everything is clear if not please let me know i will give more details.
Regards Luke
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>