Junior Analyst

Sorry I’m bit duff but when I change my following Sheet1 want to do similar gives me error (Runtime Error9) ,I think I’ve change the tweak as per my requirement
but don’t know how , appreciate your help please

Sheet1

Sitename StartDate EndDate
BF Bobbing Apple 02/05/2017 02/05/2017
BF Bobbing Apple 15/05/2017 15/05/2017
BF Bobbing Apple 01/06/2017 01/06/2017
BF Bobbing Apple 12/06/2017 12/06/2017
BF Bobbing Apple 26/06/2017 26/06/2017
XYZ 10/07/2017 10/07/2017
XYZ 10/07/2017 10/07/2017
XYZ 24/07/2017 24/07/2017
XYZ 07/08/2017 07/08/2017
XYZ 22/08/2017 22/08/2017
BF Brookers 02/05/2017 02/05/2017
BF Brookers 15/05/2017 15/05/2017
BF Brookers 30/05/2017 30/05/2017
LM North 15/05/2017 15/05/2017
LM North 30/05/2017 30/05/2017

I like see the Output as follows:

  StartDate1 EndDate1 StartDate2 EndDate2 StartDate3 EndDate3 StartDate4 EndDate5
BF Bobbing Apple 02/05/2017 02/05/2017 15/05/2017 15/05/2017 01/06/2017 01/06/2017 12/06/2017 12/06/2017
XYZ 10/07/2017 10/07/2017 24/07/2017 24/07/2017 24/07/2017 24/07/2017 07/08/2017 07/08/2017
BF Brookers 02/05/2017 02/05/2017 15/05/2017 15/05/2017 30/05/2017 30/05/2017    
LM Noth 15/05/2017 15/05/2017 30/05/2017 30/05/2017        

hope make sense

appreciate your help
Kind regards,
Farhan

By: Farhan

Leave a Reply

Your email address will not be published. Required fields are marked *