transpose data excluding some columns and rows

[34sweetness]

I receive data in a worksheet that contains items in rows across multiple columns. I want to transpose this data so that the items are contained in columns with multiple rows. I can do the “copy > paste special > transpose” but I get the same worksheet sent to me each week with additional data, and don’t want to copy/paste every time. Plus, there are some columns that I do not want to transpose and also some blank rows that I also do not want.

Does anyone have any ideas on how I can “convert” this data?

 

[erik.van.geit]

34sweetness,

Some (little) sample would help to see the problem for everybody here...

post for instance:

Main Sheet BEFORE
DATA YOU RECIEVE
what you want to happen
Main Sheet AFTER

kind regards,
Erik

 

[34sweetness]

Okay, here is an example of the worksheet I received updated each week:

Example.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	Basic Parts	Widgits		January 2005					February 2005
3				7-Jan	14-Jan	21-Jan	28-Jan		4-Feb	11-Feb	18-Feb	25-Feb
4		M725013	Small	243	255	242	234		213	248	233
5		M725015	Medium	198	279	141	246		223	170	187
6		M725020	Large	224	190	139	192		183	189	216
7		M725022	X-Large	294	271	210	428		313	363	183
8				959	995	732	1100	3786	932	970	819	0	2721
9
10		Windings		January 2005					February 2005
11				7-Jan	14-Jan	21-Jan	28-Jan		4-Feb	11-Feb	18-Feb	25-Feb
12		M725049	Round	226	174	174	162		179	135	197
13		M725052	Square	12	22	12	6		28	7	8
14				238	196	186	168	788	207	142	205	0	554
15
Sheet1

 

[34sweetness]

And this is what I would like to "Transpose" the data into:

Example.xls
	A	B	C	D
1	Date	Group	Part Number	Cases Shipped
2	7-Jan	Widgit	M725013	243
3	7-Jan	Widgit	M725015	198
4	7-Jan	Widgit	M725020	224
5	7-Jan	Widgit	M725022	294
6	7-Jan	Winding	M725049	226
7	7-Jan	Winding	M725052	12
8	14-Jan	Widgit	M725013	255
9	14-Jan	Widgit	M725015	279
10	14-Jan	Widgit	M725020	190
11	14-Jan	Widgit	M725022	271
12	14-Jan	Winding	M725049	174
13	14-Jan	Winding	M725052	22
14	21-Jan	Widgit	M725013	242
15	21-Jan	Widgit	M725015	141
16	21-Jan	Widgit	M725020	139
17	21-Jan	Widgit	M725022	210
18	21-Jan	Winding	M725049	174
19	21-Jan	Winding	M725052	12
20	28-Jan	Widgit	M725013	234
21	28-Jan	Widgit	M725015	246
22	28-Jan	Widgit	M725020	192
23	28-Jan	Widgit	M725022	428
24	28-Jan	Winding	M725049	162
25	28-Jan	Winding	M725052	6
26	4-Feb	Widgit	M725013	213
27	4-Feb	Widgit	M725015	223
28	4-Feb	Widgit	M725020	183
29	4-Feb	Widgit	M725022	313
30	4-Feb	Winding	M725049	179
Sheet3

 

[34sweetness]

Any Ideas?

I would like to set this up so that it can be easily "updated" with the new data I receive each week.

I am sent the workbook with the updated info.

Note: some months contain 4 weeks of data and some contain 5 weeks of data. It just depends on the month...

 

[erik.van.geit]

34sweetness,

To be honnest, I don't like this one.
Yhe layout to start with is difficult to implement.

Will you copy only one column a week to add at the bottom of a list?
How many basic parts do you have?

kind regards,
Erik