Nishant859_1
New Member
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.
Small Example
Raw Data
OUTPUT is
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.
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 | - |