Hi I had data in Sheet1 in different columns and I want to get in other worksheet in Transpose format.
I had created macro but getting error and only first part is working.
Table as below
Date Time (Hrs) Weight of Empty Dish (g) Weight of Dish + Drug (g) Visible Physical Change Total Weight on Exposure (g) Weight Gain (g) Weight Gain per Dose (g) % Weight Gain (g/g) Absoption Rate (g / Hr) Absorption Rate (% / Hr) Absorption Value
28-Mar-16 0 24.0812 29.6987 No Change 29.6987 0.0000 0.0000 0.0000 0.00000 0.0000 0.0000
28-Mar-16 2 24.0812 29.6987 Nominal Change 29.7850 0.0863 0.01079 1.5363 0.00539 0.7681 0.0768
28-Mar-16 4 24.0812 29.6987 Nominal Change 29.7868 0.0881 0.01101 1.5683 0.00275 0.3921 0.0392
28-Mar-16 6 24.0812 29.6987 Nominal Change 29.7840 0.0853 0.01066 1.5185 0.00178 0.2531 0.0253
28-Mar-16 8 24.0812 29.6987 Nominal Change 29.7808 0.0821 0.01026 1.4615 0.00128 0.1827 0.0183
29-Mar-16 24 24.0812 29.6987 Nominal Change 29.8440 0.1453 0.01816 2.5866 0.00076 0.1078 0.0108
30-Mar-16 48 24.0812 29.6987 Nominal Change 29.9455 0.2468 0.03085 4.3934 0.00064 0.0915 0.0092
31-Mar-16 72 24.0812 29.6987 Considerable Change 29.9843 0.2856 0.03570 5.0841 0.00050 0.0706 0.0071
1-Apr-16 96 24.0812 29.6987 Considerable Change 30.2886 0.5899 0.07374 10.5011 0.00077 0.1094 0.0109
2-Apr-16 120 24.0812 29.6987 Considerable Change 30.3644 0.6657 0.08321 11.8505 0.00069 0.0988 0.0099
3-Apr-16 144 24.0812 29.6987 Considerable Change 30.5462 0.8475 0.10594 15.0868 0.00074 0.1048 0.0105
4-Apr-16 168 24.0812 29.6987 Considerable Change 30.8050 1.1063 0.13829 19.6938 0.00082 0.1172 0.0117
5-Apr-16 192 24.0812 29.6987 Considerable Change 30.8101 1.1114 0.13893 19.7846 0.00072 0.1030 0.0103
Macro as below
Please Login or Register to view this content.
Bookmarks