You’re offline. This is a read only version of the page.
I have a set of data in three different worksheets. Shown below is a sample of data in the first 12 rows of each worksheet
I will like to
(i) combine the 3 worksheets into a single table and
(ii) add a label to each column (or header to the table). For example, the 8 columns will have headers A,B, C, D, E, F, G, H
Worksheet 1
| 119 | 42 | 135 | 25 | 16 | 129 |
| 42 | 43 | 41 | 48 | 31 | 88 |
| 153 | 31 | 49 | 120 | 114 | 140 |
| 83 | 137 | 59 | 67 | 110 | 75 |
| 16 | 140 | 89 | 143 | 20 | 30 |
| 32 | 25 | 132 | 89 | 48 | 121 |
| 93 | 40 | 84 | 114 | 121 | 74 |
| 56 | 74 | 45 | 104 | 28 | 82 |
| 25 | 58 | 117 | 100 | 85 | 133 |
| 87 | 68 | 47 | 127 | 140 | 51 |
| 95 | 24 | 81 | 102 | 85 | 102 |
| 117 | 70 | 103 | 57 | 18 | 29 |
Worksheet 2
| 5 |
| 10 |
| 2 |
| 27 |
| 12 |
| 12 |
| 12 |
| 19 |
| 10 |
| 3 |
| 21 |
| 8 |
Wrksheeet 3
| 180 |
| 131 |
| 192 |
| 125 |
| 224 |
| 200 |
| 218 |
| 184 |
| 199 |
| 224 |
| 138 |
| 174 |
Share
Report
All responses (
Answers (
395
