Hi experts,

need a macro for copying and pasting data with transpose, i have attached a sample data here.

the line items from actual data worksheet should be copy pasted in a new worksheet like the data in the desired data worksheet.

copy paste action has loop till the available data in the actual data worksheet.

please support

rajBook1.xlsx