Copy some specific columns whose header is merge

[guptasweb]

I have one excel file in which header is merged and I want ABC2024 data.under this header 12 columns are there i.e Jan,Feb,MAr,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec and one column before the ABC2024.is it possible?

 

[Joe4]

Welcome to the Board!

It is very hard to completely grasp what you need from that brief description. Would you be able to post an image of what your data looks like to start, and then an image of your desired output? Just to be sure to remove any sensitive data first.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[guptasweb]

Welcome to the Board!

It is very hard to completely grasp what you need from that brief description. Would you be able to post an image of what your data looks like to start, and then an image of your desired output? Just to be sure to remove any sensitive data first.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Joe4]

Is that the BEFORE or the AFTER image?

I asked if you could show us what your data look like at the start AND what you would like your desired output to look like.

 

[guptasweb]

above one is my input file

output file

 

[guptasweb]

yes,I have shared both images.First one is my Start image and 2nd image is my desired output

 

[Joe4]

It looks to me like you just want to hide or delete columns D-V.
Is it really that simple, or is there more to it?

If there is more to it, please explain in detail.

 

[guptasweb]

Sample23.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
2				2024 ACTUAL OEE %													2024 BUDGET OEE %
3	Process Type	Part Family Description		A	A	A	A	A	A	A	A	A	A	A	A		B	B	B	B	B	B	B	B	B	B	B	B
4				####	####	####	####	####	####	Jul-24	####	####	####	####	####		####	####	####	####	####	####	Jul-24	####	####	####	####	####
5
6
7
8
9
10	Machining	Diff Case Rear VW 8.9" Locker - Machining	Diff Case Rear Machining	86.10%	86.10%	86.10%	86.1%	86.1%									86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
11	Machining	Diff Case Rear VW 8.9" Open - Machining															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
12	Machining	Diff Case Rear GMI 700 8.6" Open - Machining															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
13
14	Assembly	Diff Case Rear VW 8.9" Locker - Assy															90.3%	90.3%	90.3%	90.3%	90.3%	90.3%	90.4%	90.4%	90.4%	90.4%	90.4%	90.4%
15	Assembly	Diff Case Rear VW 8.9" Open - Assy															90.3%	90.3%	90.3%	90.3%	90.3%	90.3%	90.4%	90.4%	90.4%	90.4%	90.4%	90.4%
16	Assembly	Diff Case Rear GMI 700 8.6" Open - Assy															90.3%	90.3%	90.3%	90.3%	90.3%	90.3%	90.4%	90.4%	90.4%	90.4%	90.4%	90.4%
17
18	Machining	VW RPU - Pinion Flange Machining	Pinion Flange Machining	86.80%	86.80%	86.70%	86.9%	86.8%									86.7%	86.7%	86.7%	86.7%	86.7%	86.7%	86.8%	86.8%	86.8%	86.8%	86.8%	86.8%
19	Machining	GMI-700/31UX Rear - Pinion Flange Machining															86.7%	86.7%	86.7%	86.7%	86.7%	86.7%	86.8%	86.8%	86.8%	86.8%	86.8%	86.8%
20	Machining	GMI-700/31UX Front - Pinion Flange Machining															86.7%	86.7%	86.7%	86.7%	86.7%	86.7%	86.8%	86.8%	86.8%	86.8%	86.8%	86.8%
21
22	Machining	VW 8.9" - Ring Gear Green	Ring Gear Green	86.20%	86.05%	86.00%	86.0%	86.1%									86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
23	Machining	GMI-700 & 31UX 8.6" - Ring Gear Green															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
24	Machining	GM Front 7.6" - Ring Gear Green															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
25
26	Machining	VW 8.9" - Pinion Green	Pinion Gear Green	86.10%	86.10%	86.10%	86.0%	86.0%									86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
27	Machining	GMI-700 & 31UX - Pinion Green															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
28	Machining	GM Front 7.6" - Pinion Green															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
29
30	Forming	GEARS - Heat Treat VW RPU 8.9"															85.1%	85.1%	85.1%	85.1%	85.1%	85.1%	85.2%	85.2%	85.2%	85.2%	85.2%	85.2%
31	Forming	GEARS - Heat Treat GMI-700/31UX 8.6"															85.1%	85.1%	85.1%	85.1%	85.1%	85.1%	85.2%	85.2%	85.2%	85.2%	85.2%	85.2%
32	Forming	GEARS - Heat Treat GMI-700/31UX 7.6"															85.1%	85.1%	85.1%	85.1%	85.1%	85.1%	85.2%	85.2%	85.2%	85.2%	85.2%	85.2%
33	Forming	Spider - Heat Treat GMI-700 Propshaft Front Aux.															85.1%	85.1%	85.1%	85.1%	85.1%	85.1%	85.2%	85.2%	85.2%	85.2%	85.2%	85.2%
34	Forming	Spider - Heat Treat GMI-700 Propshaft Rear 1pc															85.1%	85.1%	85.1%	85.1%	85.1%	85.1%	85.2%	85.2%	85.2%	85.2%	85.2%	85.2%
35	Forming	Spider - Heat Treat GMI-700 Propshaft Rear 2pc															85.1%	85.1%	85.1%	85.1%	85.1%	85.1%	85.2%	85.2%	85.2%	85.2%	85.2%	85.2%
36	Forming	Bearing Cup - Heat Treat GMI-700 Propshaft Front Aux.															85.1%	85.1%	85.1%	85.1%	85.1%	85.1%	85.2%	85.2%	85.2%	85.2%	85.2%	85.2%
37	Forming	Bearing Cup - Heat Treat GMI-700 Propshaft Rear 1pc															85.1%	85.1%	85.1%	85.1%	85.1%	85.1%	85.2%	85.2%	85.2%	85.2%	85.2%	85.2%
38	Forming	Bearing Cup - Heat Treat GMI-700 Propshaft Rear 2pc															85.1%	85.1%	85.1%	85.1%	85.1%	85.1%	85.2%	85.2%	85.2%	85.2%	85.2%	85.2%
39
40	Machining	VW RPU 8.9" - GEARS SET	Gears Set	86.20%	86.20%	83.70%	86.0%	86.3%									86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
41	Machining	GMI-700/31UX 8.6" - GEARS SET															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
42	Machining	GM Front 7.6" - GEARS SET															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
43
44	Machining	VW RPU GEARS - Lubrite															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
45	Machining	GMI-700/31UX REAR GEARS - Lubrite															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
46	Machining	GMI-700/31UX FRONT GEARS - Lubrite															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
47	Machining	VW RPU DIFF REAR - Lubrite															86.0%	86.0%	86.0%	86.0%	86.0%	86.0%	86.1%	86.1%	86.1%	86.1%	86.1%	86.1%
After

 

[guptasweb]

that is my actual output.Could you pls help me to resolve this issue

 

[Joe4]

Please answer the questions I asked in post #7!
Remember, while you are familiar with your issue and known exactly what you want to do, we are not. We are reliant on you to fully and clearly communicate exactly what it is that you are trying to accomplish.

Also, are you trying to do this "in place", or on a new sheet?
If on a new sheet, it appears that maybe you just need copy columns B-D and W-AH. Is that correct?
Are the values in those columns in the original sheet hard-coded values, formulas, or a mixture of the two?
And if copying to a new sheet, does this sheet already exist, or does it need to be created?
What are the names of the sheets?

Please answer ALL these questions!