I have data/table with multiple rows with 6 columns.
I have such tables/data (hundreds of them) in one excel sheets separated by two empty rows.. each data/table must be considered as one set.
All I want is to copy the last three columns (all the rows) below the first three columns as rows based on each set.
for instance, for the below table,
col1 col2 col3 col4 col5 col6
1 2 3 4 5 6
11 12 13 14 15 16
21 22 23 24 25 26
31 32 33 34 35 36
col7 col8 col9 col10 colx coly
7 8 9 10 x1 y1
17 18 19 20 x2 y2
27 28 29 30 x3 y3
37 38 39 40 x4 y4
result must be
col1 col2 col3
1 2 3
11 12 13
21 22 23
31 32 33
col4 col5 col6
4 5 6
14 15 16
24 25 26
34 35 36
col7 col8 col9
7 8 9
17 18 19
27 28 29
37 38 39
col10 colx coly
10 x1 y1
20 x2 y2
30 x3 y3
40 x4 y4
If this is not clear, I have attached a table with two example sets and expected results.
Please help.
I have hundreds of sets in one excel sheet. So, I need a formula or program for this purpose.
Bookmarks