Q: columns to rows
Hello,
Sheet1 has column based data such as there are values in A1,B1,C1,..
Now I need to create Steet2 that holds row based data such as
A1-A1,B1-A2,C1-A3 and change the background color of A1,A2,A3, if the
data in A1,B1,C1 in Sheet1 is zero.
How can I do this?
Thanks,
|