help to Write a code to put value copy two tyms and columb values to row

[pranav]

Hello n thanks,
i have a sheets with data

 

DATA
                 jan                                           feb                                        mar 
         provisional                   real                real                provisonal            real            real 
cca         123                       455                 455                   344                  466
dde          445                      455                 445                   555                   65
eer           333                      333                 445                   6666                 56             78
 
rrr             544                      34r                 455                   543                   56            556
 
ffr             455                       454                1111                 455                   22             76
 

now i want a result

cca     provisional         123     344     
cca     real                   455     445   466

dde     provisional        445    555    
dde     real                 455     445    65
 
eer     provisional         333    6666
eer    real                   333   445     56   78       (as real is two times)

rrr     provisional           544       543 
  
rrr     real                    34r      455    56      556

can sum one please help me i want a vba code for the button on the sheet 1 and gives result on sheet 2 .....

Thanks in advance

[SamT]

Please upload workbook with two sheets: One as original and one as desired.

Go Advanced and Manage Attachments.

[pranav]

Please upload workbook with two sheets: One as original and one as desired.

Go Advanced and Manage Attachments.

thank you for response i have attached sheet with data which starts at row 41 and a button and i hav shown the result the way i would like to on the Result sheet.


thanks