Pull data from a table into a specific structure at another sheet

[murka]

Hey guys,

I work in a chemical laboratory, and we send structured reports to our clients.

In the past this was done manually, and quite well, but lately we got a few large projects and compiling the reports has become a nightmare...

It's not an option right now to change the report structure, but I'm trying to create some sort of template the will pull data from orderly rows by sample #ID into the report structure.

So, in the first sheet I got the data table, with samples identified by number (1 2 3 for example), and the headers A B C D representing parematers below as a1 a2 a3 a4 etc'

In the actual report the sample data is in a "info brick" on the top of the page, and is structured as the headers in one row, and the parameters for each sample beside each header (See attached pictures for examples)

This repeats for every sample row in constant intervals (In the pictures, first sample info brick starts at row 1, then the next one at row 50, the next one at row 100 etc' until the last row.

Like I said, we used to copy and paste all the information manually, but lately when we get reports with 50+ samples inside them it became very tedious...

Thanks in advance.

 

[alansidman]

We cannot manipulate data in a picture. Please reload your sample source data and mocked up solution using XL2BB so that we don't have to retype your data.

 

[murka]

We cannot manipulate data in a picture. Please reload your sample source data and mocked up solution using XL2BB so that we don't have to retype your data.

Sorry, didn't know that was even an option, I've now tried downloading the add-in but it says that excel has blocked it.

Best I can do atm is share a link to google sheets?

Sample

Sheet1 #ID,A,B,C,D,E,F,G 1,a1,b1,c1,d1,e1,f1,g1 2,a2,b2,c2,d2,e2,f2,g2 3,a3,b3,c3,d3,e3,f3,g3 4,a4,b4,c4,d4,e4,f4,g4 5,a5,b5,c5,d5,e5,f5,g5 6,a6,b6,c6,d6,e6,f6,g6 7,a7,b7,c7,d7,e7,f7,g7 8,a8,b8,c8,d8,e8,f8,g8 9,a9,b9,c9,d9,e9,f9,g9 10,a10,b10,c10,d10,e10,f10,g10 A,a1,D,d1 B,b1,E,e1 C,c1,F,f1 A,a2,D

docs.google.com

It's just a sample range anyway, I have a source table hundreds of rows long, and I need to arrange the data in a specific format.
Because the amount of data is so large, I can't do it manually...

 

[murka]

Book.xlsm
	A	B	C	D	E	F	G	H
1	#ID	A	B	C	D	E	F	G
2	1	a1	b1	c1	d1	e1	f1	g1
3	2	a2	b2	c2	d2	e2	f2	g2
4	3	a3	b3	c3	d3	e3	f3	g3
5	4	a4	b4	c4	d4	e4	f4	g4
6	5	a5	b5	c5	d5	e5	f5	g5
7	6	a6	b6	c6	d6	e6	f6	g6
8	7	a7	b7	c7	d7	e7	f7	g7
9	8	a8	b8	c8	d8	e8	f8	g8
10	9	a9	b9	c9	d9	e9	f9	g9
11	10	a10	b10	c10	d10	e10	f10	g10
12
13
14
15
16
17
18
19
20	A	a1	D	d1
21	B	b1	E	e1
22	C	c1	F	f1
23
24
25
26
27
28
29
30	A	a2	D	d2
31	B	b2	E	e2
32	C	c2	F	f2
Template

 

[murka]

Anyone?