Macro combine to columns

[MDuff]

I have a sheet that has a information in multiple columns The information is always grouped in to 6 columns

Example:

B-G Data I-N Data etc.

Is there a macro that will take all the information on the whole sheet and put it in columns B-G so I can then run a Pivot Table on it.

Any help would be appreciated also This is hard for me to explain so if this is hard to understand please let me know if you can understand it And I will try to explain it in a different way.

thanks a Lot in advance for your time and help

 

[Joe C]

You can't concantenate the columns?

 

[MDuff]

You can't concantenate the columns?

Sorry Joe I don't really understand what you mean. What I have been doing Is Copying and pasting the Information in to one set of columns but this is very time consuming. I am looking for an easier way to do this.

thanks for your help

 

[Joe C]

Try using the concantenate function.
You can access it through the function wizard.
Are you trying to combine the 6 columns into one column?

 

[MDuff]

Try using the concantenate function.
You can access it through the function wizard.
Are you trying to combine the 6 columns into one column?

Joe This is a small example of what I am trying to achieve the actual information I have has 6 columns of data per "Group" Like I said This is a little hard for me to explain I hope this Example Helps a out so you can understand what I'm looking for

thanks

Book5
	A	B	C	D	E	F	G	H
1	WhatIhave
2	Group1			Group2			Group3
3	Data1	Data2		Data1	Data2		Data1	Data2
4	1	2		3	4		5	6
5
6
7
8	WhatIneed
9	Data1	Data2
10	1	2
11	3	4
12	5	6
Sheet1

 

[Joe C]

me2.xls
	A	B	C	D	E	F	G	H
1
2
3
4	A	1		c	2		e	3
5	g	4		i	5		k	6
6	m	7		o	8		q	9
7
8
9
10
11
12
13
14	Numberedcolumns			Results
15	4	0	4	0	A	1
16	5	0.333333	4.333333	1	c	2
17	6	0.666667	4.666667	2	e	3
18	7	1	5	0	g	4
19	8	1.333333	5.333333	1	i	5
20	9	1.666667	5.666667	2	k	6
21	10	2	6	0	m	7
22	11	2.333333	6.333333	1	o	8
23	12	2.666667	6.666667	2	q	9
Sheet1

This shoul work. Let me know if you need help with it.

 

[Joe C]

The formul;as didnt seem to come through first time.

me2.xls
	A	B	C	D	E	F	G	H
1
2
3
4	A	1		c	2		e	3
5	g	4		i	5		k	6
6	m	7		o	8		q	9
7
8
9
10
11
12
13
14	Numberedcolumns			Results
15	4	0	4	0	A	1
16	5	0.333333	4.333333	1	c	2
17	6	0.666667	4.666667	2	e	3
18	7	1	5	0	g	4
19	8	1.333333	5.333333	1	i	5
20	9	1.666667	5.666667	2	k	6
21	10	2	6	0	m	7
22	11	2.333333	6.333333	1	o	8
23	12	2.666667	6.666667	2	q	9
Sheet1

 

[Joe C]

Im sorry but the formulas are not going through. They did go through on my other link.
If you want to see go there it is message from Joe C on questions about this board.

 

[MDuff]

Joe
thanks for the Help I will look through your forulas and see if I can get them tom work

Thanks once more