Is there a possibility of copy past from one sheet to another using macros. the data in sheet1 is in vertical way,
IDAbssSCTCC
SourceProcessDtaProcessDtaProcessDtaTotal
a1030545
b1030545
c1030545
d1030545
e1030545
f1030545
g1030545
Were as the data need to be copy in sheet2 in horizontally way, below is the output.
aTCC5
aSC30
aAbss10
Total45
bTCC5
bSC30
bAbss10
Total45
any idea
IDAbssSCTCC
SourceProcessDtaProcessDtaProcessDtaTotal
a1030545
b1030545
c1030545
d1030545
e1030545
f1030545
g1030545
Were as the data need to be copy in sheet2 in horizontally way, below is the output.
aTCC5
aSC30
aAbss10
Total45
bTCC5
bSC30
bAbss10
Total45
any idea