I am working on 2 set of data in excel.
First data set- Input data sheet –
Second data set- Input data sheet –
I am going to another sheet for reporting after every execution –
Although I am able to concatenate Project Id correctly but Transaction Number is not coming as per screenshot.
Any help will be appreciated.