I have received an complex excel file format which contains data into various different columns and required to get these data into rows.
Please find attached sample file which contains input at the top and required output in new excel file.
Can you please provide any reference or sample code to achieve this. I find this quite complex to code this in vb macro.
Thanks in advance.