Macro to copy column to rows

ranga24 1 Posts Tuesday November 21, 2017Registration date November 21, 2017 Last seen - Nov 21, 2017 at 01:08 PM
Hi All,
I have a requirement where the data looks like ,
A B C
1 APRIL MARCH DEC
2 20 35 60
3 FEB MAY THUS
4 30 60 140
5 JAN JULY FRI
6 20 80 60

I need data like
A B
1 April 20
2 feb 30
3 jan 20
4 march 35
5may 60
6july 80
7dec 60
8thus 140
9fri 60

Thank you all in advance
See more