Looking Macro..
I have data below form in the spreedsheet
There's data like that
A B Exp Actual Exp1 Actual1 Exp2 Actual2
1 abcd test1 test2 test3 test4 test 5 test6
2 bcde test2 test1 test4 test3 test 6 test 5
3 cdef test4 test3 test2 test1 test 7 test 8
A,B,Exp,Actual,Exp1,Actual1,Exp2,Actual2 column names
I need it in the below form
All the expected, actual values should display in the two columns as mentioned below format for each row.
A B Exp Actual
1 abcd test1 test2
test3 test4
test 5 test6
2 bcde test2 test1
test4 test3
test 6 test 5
3 cdef test4 test3
test2 test1
test 7 test 8
Let me know if you have any quries
Attached sample.xls for your reference
Bookmarks