This is very simple, but I am still struggling how to write the script correctly. So I have a table that have information in multiple columns in following layout
A | B | C | B | C | B | C |
10119794 | 5281 | 0 | 0278 | 1 | 2392 | 2 |
1066246 | 5281 | 10 | 0278 | 24 | 2392 | 10 |
1047076 | 5281 | 15 | 0278 | 9 | 2392 | 15 |
The goal is find the correct VBA routine to cut/extract data from columns to rows in following layout, keeping only table title in another sheet:
A | B | C |
10119794 | 5281 | 0 |
1066246 | 5281 | 10 |
1047076 | 5281 | 15 |
10119794 | 0278 | 1 |
1066246 | 0278 | 24 |
1047076 | 0278 | 9 |
10119794 | 2392 | 2 |
1066246 | 2392 | 10 |
1047076 | 2392 | 15 |
Maybe there are the solution?
Very appreciate any help.
Thanks