VBA Macro for copying multiple column in one column with condition

[Nikku859]

Good Evening Experts,

Hope you all are doing well & safe !

Looking help with VBA code to copying multiple column in one column
but there is condition i.e. Column 1 & Column 2 required in repetition & also required header
for detail understanding i am attaching workbook, Raw Tab contain Data, & Output is the tab which is required thru Code
Output tab in attached file is linked with Raw data just to better understanding, but actually data not required to Links.
&
can we link VBA code macro button in a separate sheet
when we click button code will create a new sheet with output data

Small Example
Raw Data
Centre Function Header 1 Header 2 Header 3
AP PRO
100​
244​
30​
EM SAA
112.3​
33.7​
NAM FAC
126.1​

OUTPUT is
Centre Function Header Amount
AP PRO Header 1 100.00
EM SAA Header 1 112.30
NAM FAC Header 1 126.10
AP PRO Header 2 244.00
EM SAA Header 2 -
NAM FAC Header 2 -
AP PRO Header 3 30.00
EM SAA Header 3 33.70
NAM FAC Header 3 -

[jindon]

try

Please Login or Register  to view this content.

[Nikku859]

Thanks a Lot