i need to transpose data as within the examples below as i have the original data as given within the first example and need to transpose it as given within the second example ,
as i need the "SIZES of 35-36-37-38-39-40-41" to keep repeating while the given numbers are changing as within example #2 below .
EXAMPLE #1 :
THE ORIGINAL DATA :
<tbody>
</tbody>
EXAMPLE #2
TO BECOME LIKE THIS :
<tbody>
</tbody>
And is it possible to fill the blank cells with the same upper values ?
as i need the "SIZES of 35-36-37-38-39-40-41" to keep repeating while the given numbers are changing as within example #2 below .
EXAMPLE #1 :
THE ORIGINAL DATA :
A | B | C | D | E | F | G | H | I | J | K | |
sizes | |||||||||||
1 | ITEM NO | DESCRIPTION | COLOR | U/PRICE | 35 | 36 | 37 | 38 | 39 | 40 | 41 |
2 | Q8-8940-2 | WOMEN | SILVER | US$10.00 | 1 | 2 | 3 | 4 | 5 | 6 | |
3 | WOMEN | GOLD | US$10.00 | 7 | 8 | 9 | 10 | 11 | 12 | ||
4 | QS-2307-32 | MEN | WHITE | US$6.70 | 13 | 14 | 15 | 16 | 17 | 18 | |
5 | MEN | BLACK | US$6.70 | 19 | 20 | 21 | 22 | 23 | 24 | ||
6 | MEN | GOLD | US$6.70 | 25 | 26 | 27 | 28 | 29 | 30 | ||
7 | 270# | KIDS | BLACK | US$10.30 | 31 | 32 | 33 | 34 | 35 | 36 | |
8 | KIDS | PINK | US$10.30 | 37 | 38 | 39 | 40 | 41 | 42 | ||
9 | M0-1116-1039 | UNISEX | BEIGE | US$5.80 | 43 | 44 | 45 | 46 | 47 | 48 | |
10 | UNISEX | PINK | US$5.80 | 49 | 50 | 51 | 52 | 53 | 54 |
<tbody>
</tbody>
EXAMPLE #2
TO BECOME LIKE THIS :
M | N | O | P | Q | R | |
1 | ITEM NO | DESCRIPTION | COLOR | U/PRICE | sizes | |
2 | Q8-8940-2 | WOMEN | SILVER | US$10.00 | 35 | |
3 | 36 | 1 | ||||
4 | 37 | 2 | ||||
5 | 38 | 3 | ||||
6 | 39 | 4 | ||||
7 | 40 | 5 | ||||
8 | 41 | 6 | ||||
9 | Q8-8940-2 | WOMEN | GOLD | US$10.00 | 35 | |
10 | 36 | 7 | ||||
11 | 37 | 8 | ||||
12 | 38 | 9 | ||||
13 | 39 | 10 | ||||
14 | 40 | 11 | ||||
15 | 41 | 12 | ||||
16 | QS-2307-32 | MEN | WHITE | US$6.70 | 35 | |
17 | 36 | 13 | ||||
18 | 37 | 14 | ||||
19 | 38 | 15 | ||||
20 | 39 | 16 | ||||
21 | 40 | 17 | ||||
22 | 41 | 18 | ||||
23 | QS-2307-32 | MEN | BLACK | US$6.70 | 35 | |
24 | 36 | 19 | ||||
25 | 37 | 20 | ||||
26 | 38 | 21 | ||||
27 | 39 | 22 | ||||
28 | 40 | 23 | ||||
29 | 41 | 24 | ||||
30 | QS-2307-32 | MEN | GOLD | US$6.70 | 35 | |
31 | 36 | 25 | ||||
32 | 37 | 26 | ||||
33 | 38 | 27 | ||||
34 | 39 | 28 | ||||
35 | 40 | 29 | ||||
36 | 41 | 30 | ||||
37 | 270# | KIDS | BLACK | US$10.30 | 35 | |
38 | 36 | 31 | ||||
39 | 37 | 32 | ||||
40 | 38 | 33 | ||||
41 | 39 | 34 | ||||
42 | 40 | 35 | ||||
43 | 41 | 36 | ||||
44 | 270# | KIDS | PINK | US$10.30 | 35 | |
45 | 36 | 37 | ||||
46 | 37 | 38 | ||||
47 | 38 | 39 | ||||
48 | 39 | 40 | ||||
49 | 40 | 41 | ||||
50 | 41 | 42 | ||||
51 | M0-1116-1039 | UNISEX | BEIGE | US$5.80 | 35 | 43 |
52 | 36 | 44 | ||||
53 | 37 | 45 | ||||
54 | 38 | 46 | ||||
55 | 39 | 47 | ||||
56 | 40 | 48 | ||||
57 | 41 | |||||
58 | M0-1116-1039 | UNISEX | PINK | US$5.80 | 35 | 49 |
59 | 36 | 50 | ||||
60 | 37 | 51 | ||||
61 | 38 | 52 | ||||
62 | 39 | 53 | ||||
63 | 40 | 54 | ||||
64 | 41 |
<tbody>
</tbody>
And is it possible to fill the blank cells with the same upper values ?
Last edited: