Insert a new column after each column and populate its value based on the column adjacent to it

[Amir Wisal]

Hi Good People,

Can you please help me add a new column after each column (starting from column B) to the very end and populate the values of the newly inserted column based on row 1.

For example, the code shall insert a new column after column B and also populate the newly inserted column with the value OS (as mentioned in the column right before it in Cell "B1". Same approach goes for all other columns. After column C, i will insert a new column and the value of that column shall be the value of cell C1 and so on.

Please note that i want the newly inserted column to have the value mentioned in row 1 (obviously based on the relevant column) however i want that value to be pasted all the way down the very end of the data. In this particular spreadsheet, i have 46 rows which might be changed next time so i want the code to be dynamic

I hope i am clear with my instruction. Sample file is also attached for your reference. Desired result is attached as image

Thank you.

Dummy Data.xlsx
	A
1	Value
Sheet2

 

[Amir Wisal]

Hi All,

Sorry i copied the wrong range before.

Dummy Data.xlsx
	A	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	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW
1	Value	OS	Dimensions	Weight	SIM	Colors	2Gncy	3G	4G	Chipsetsor	Technologyy	Size	Resolution	Protection	Extra	Column1	Card	Features	Front	WLANtivity	Bluetooth	GPS	USB	NFC	Data	Sensorses	Audio	Browser	g	Games	Torch	Capacityy	Talktime	Musicplay	Price	Ratings	e Ratgs	5G	CPUsor	Chipset	GPU	Standby	Pri	New	Radio	Standbyy	Pr	Pric	Browseres
2	Apple iPhone 11	IOS 13	150.9 x 75.7 x 8.3 mm	189 g	Dual Sim, Dual Standby (Nano-SIM)	Black, Green, Yellow, Purple, Red, White	SIM1: GSM 850 / 900 / 1800 / 1900SIM2: GSM 850 / 900 / 1800 / 1900	HSDPA 850 / 900 / 1700(AWS) / 1900 / 2100	LTE band 1(2100), 2(1900), 3(1800), 4(1700/2100), 5(850), 7(2600), 8(900), 12(700), 13(700), 17(700), 18(800), 19(800), 20(800), 25(1900), 26(850), 28(700), 29(700), 30(2300), 34(2000), 38(2600), 39(1900), 40(2300), 41(2500), 66(1700/2100)	Apple A13 (7 nm+)	Liquid Retina IPS LCD Capacitive Touchscreen, 16M Colors, Multitouch	6.1 Inches	828 x 1792 Pixels (~324 PPI)	Scratch-resistant glass			No	Phase detection, OIS, Geo-tagging, touch focus, face/smile detection, HDR (photo/panorama), Video (2160p@24/30/60fps, 1080p@30/60/120/240fps, HDR, stereo sound rec.)	Dual 12 MP TOF 3D camera, HDR, Video (2160p@24/30/60fps, 1080p@30/60/120fps, gyro-EIS)	Wi-Fi 802.11 a/b/g/n/ac/ad, dual-band, hotspot	v5.0 with A2DP, LE	Yes + A-GPS support, & GLONASS, GALILEO, QZSS	2.0, proprietary reversible connector	Yes	GPRS, Edge, 3G HSPA, 4G LTE-A, EV-DO Rev.A 3.1 Mbps	Accelerometer, Face ID, Barometer, Compass, Gyro, Proximity	Lightning to 3.5 mm headphone jack adapter, MP3/WAV/AAX+/AIFF/Apple Lossless player, MP4/H.264 player, Speaker Phone	HTML5 (Safari)	iMessage, SMS (threaded view), MMS, Email, Push Email	Built-in + Downloadable	Yes	(Li-ion Non removable), 3110 mAh	up to 17 hrs	up to 65 hrs	Price in Rs: 144,900 Price in USD: $1080	Average Rating is 4.1 stars - basears - based on 216 user reviews.
3	Apple iPhone 11 Pro	IOS 13	144 x 71.4 x 8.1 mm	188 g	Dual Sim, Dual Standby (Nano-SIM)	Space Gray, Silver, Gold, Midnight Green	SIM1: GSM 850 / 900 / 1800 / 1900SIM2: GSM 850 / 900 / 1800 / 1900	HSDPA 850 / 900 / 1700(AWS) / 1900 / 2100	LTE band 1(2100), 2(1900), 3(1800), 4(1700/2100), 5(850), 7(2600), 8(900), 12(700), 13(700), 17(700), 18(800), 19(800), 20(800), 25(1900), 26(850), 28(700), 29(700), 30(2300), 34(2000), 38(2600), 39(1900), 40(2300), 41(2500), 66(1700/2100)	Apple A13 (7 nm+)	Super Retina XDR OLED Capacitive Touchscreen, 16M Colors, Multitouch	5.8 Inches	1125 x 2436 Pixels (~463 PPI)	Scratch-resistant glass			No	f/1.8 & f/2.4, phase detection, OIS, 2x optical zoom, Geo-tagging, simultaneous 4K video and 8MP image recording, touch focus, face/smile detection, HDR (photo/panorama), Video (2160p@24/30/60fps, 1080p@30/60/120/240fps, HDR, stereo sound rec.)	Dual 12 MP TOF 3D camera, HDR, Video (2160p@24/30/60fps, 1080p@30/60/120fps, gyro-EIS))	Wi-Fi 802.11 a/b/g/n/ac/ad, dual-band, hotspot	v5.0 with A2DP, LE	Yes + A-GPS support, & GLONASS, GALILEO, QZSS	2.0, proprietary reversible connector	Yes	GPRS, Edge, 3G (HSPA 42.2/5.76 Mbps), 4G (LTE-A 1.6 Gbps DL, EV-DO Rev.A 3.1 Mbps)	Accelerometer, Face ID, Barometer, Compass, Gyro, Proximity	Lightning to 3.5 mm headphone jack adapter, MP3/WAV/AAX+/AIFF/Apple Lossless player, MP4/H.264 player, Speaker Phone	HTML5 (Safari)	iMessage, SMS (threaded view), MMS, Email, Push Email	Built-in + Downloadable	Yes	(Li-ion Non removable), 3190 mAh	up to 18 hrs	up to 65 hrs	Price in Rs: 207,800 Price in USD: $1549		Average Rating is 4 stars - bass - based on 98 user reviews.
4	Apple iPhone 11 Pro Max	IOS 13	157.5 x 77.4 x 8.1 mm	226 g	Dual Sim, Dual Standby (Nano-SIM)	Space Gray, Silver, Gold, Midnight Green	SIM1: GSM 850 / 900 / 1800 / 1900SIM2: GSM 850 / 900 / 1800 / 1900	HSDPA 850 / 900 / 1700(AWS) / 1900 / 2100	LTE band 1(2100), 2(1900), 3(1800), 4(1700/2100), 5(850), 7(2600), 8(900), 12(700), 13(700), 17(700), 18(800), 19(800), 20(800), 25(1900), 26(850), 28(700), 29(700), 30(2300), 34(2000), 38(2600), 39(1900), 40(2300), 41(2500), 66(1700/2100)	Apple A13 (7 nm+)	Super Retina XDR OLED Capacitive Touchscreen, 16M Colors, Multitouch	6.5 Inches	1242 x 2688 Pixels (~456 PPI)	Scratch-resistant glass			No	phase detection, OIS, 2x optical zoom, Geo-tagging, touch focus, face/smile detection, HDR (photo/panorama), Video (2160p@24/30/60fps, 1080p@30/60/120/240fps)	Dual 12 MP + TOF 3D camera, HDR, Video (2160p@24/30/60fps, 1080p@30/60/120fps, gyro-EIS)	Wi-Fi 802.11 a/b/g/n/ac, dual-band, hotspot	v5.0 with A2DP, LE	Yes + A-GPS support, & GLONASS, GALILEO, QZSS	2.0, proprietary reversible connector	Yes	GPRS, Edge, 3G (HSPA 42.2/5.76 Mbps), 4G (LTE-A 1.6 Gbps DL, EV-DO Rev.A 3.1 Mbps)	Accelerometer, Face ID, Barometer, Compass, Gyro, Proximity	Lightning to 3.5 mm headphone jack adapter, MP3/WAV/AAX+/AIFF/Apple Lossless player, MP4/H.264 player, Speaker Phone	HTML5 (Safari)	iMessage, SMS (threaded view), MMS, Email, Push Email	Built-in + Downloadable	Yes	(Li-ion Non removable), 3500 mAh	up to 20 hrs	up to 80 hrs	Price in Rs: 226,599 Price in USD: $1689	Average Rating is 3.9 stars - basears - based on 218 user reviews.
5	Apple iPhone 12	IOS 14.1	146.7 x 71.5 x 7.4 mm	164 g	Dual Sim, Dual Standby or eSIM (Nano-SIM)	Black, White, Red, Green, Blue	SIM1: GSM 850 / 900 / 1800 / 1900SIM2: GSM 850 / 900 / 1800 / 1900	HSDPA 850 / 900 / 1700(AWS) / 1900 / 2100	LTE band 1(2100), 2(1900), 3(1800), 4(1700/2100), 5(850), 7(2600), 8(900), 12(700), 13(700), 17(700), 18(800), 19(800), 20(800), 25(1900), 26(850), 28(700), 29(700), 30(2300), 34(2000), 38(2600), 39(1900), 40(2300), 41(2500), 66(1700/2100)		Super Retina XDR OLED Capacitive Touchscreen, 16M Colors, Multitouch	6.1 Inches	1170 x 2532 Pixels (~457 PPI)	Scratch-resistant glass, oleophobic coating			No	Phase detection, OIS, Geo-tagging, touch focus, face/smile detection, HDR (photo/panorama), Video (4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, Dolby Vision HDR (up to 30fps), stereo sound rec.)	Dual 12 MP, f/2.2, 23mm (wide), 1/3.6 + SL 3D, (depth/biometrics sensor), HDR, Video (4K@24/30/60fps, 1080p@30/60/120fps, gyro-EIS)	Wi-Fi 802.11 a/b/g/n/ac/6, dual-band, hotspot	v5.0 with A2DP, LE	Yes + A-GPS support, & GLONASS, GALILEO, QZSS	Lightning, USB 2.0	Yes	GPRS, Edge, 3G (HSPA 42.2/5.76 Mbps), 4G LTE-A, 5G capable, EV-DO Rev.A 3.1 Mbps	Accelerometer, Compass, Face ID, Gyro, Proximity	Lightning to 3.5 mm headphone jack adapter, MP3/WAV/AAX+/AIFF/Apple Lossless player, MP4/H.264 player, Speaker Phone	HTML5 (Safari)	iMessage, SMS (threaded view), MMS, Email, Push Email	Built-in + Downloadable	Yes	(Li-ion Non removable), 2815 mAh		up to 65 hrs	Price in Rs: 175,520 Price in USD: $1088	Average Rating is 4.7 stars - basars - based on 36 user reviews.		SA/NSA/Sub6/mmWave	Hexa-core (2 x 3.1 GHz Firestorm + 4 x 1.8 GHz Icestorm)	Apple A14 Bionic (5 nm)	Apple GPU (4-core graphics)	up to 17 hrs
6	Apple iPhone 12 Mini	IOS 14.1	131.5 x 64.2 x 7.4 mm	135 g	Dual Sim, Dual Standby or eSIM (Nano-SIM)	Black, White, Red, Green, Blue	SIM1: GSM 850 / 900 / 1800 / 1900SIM2: GSM 850 / 900 / 1800 / 1900	HSDPA 850 / 900 / 1700(AWS) / 1900 / 2100	LTE band 1(2100), 2(1900), 3(1800), 4(1700/2100), 5(850), 7(2600), 8(900), 12(700), 13(700), 17(700), 18(800), 19(800), 20(800), 25(1900), 26(850), 28(700), 29(700), 30(2300), 34(2000), 38(2600), 39(1900), 40(2300), 41(2500), 66(1700/2100)		Super Retina XDR OLED Capacitive Touchscreen, 16M Colors, Multitouch	5.4 Inches	1080 x 2340 Pixels (~477 PPI)	Scratch-resistant glass, oleophobic coating			No	Phase detection, OIS, Geo-tagging, touch focus, face/smile detection, HDR (photo/panorama), Video (4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, Dolby Vision HDR (up to 30fps), stereo sound rec.)	Dual 12 MP, f/2.2, 23mm (wide), 1/3.6 + SL 3D, (depth/biometrics sensor), HDR, Video (4K@24/30/60fps, 1080p@30/60/120fps, gyro-EIS)	Wi-Fi 802.11 a/b/g/n/ac/6, dual-band, hotspot	v5.0 with A2DP, LE	Yes + A-GPS support, & GLONASS, GALILEO, QZSS	Lightning, USB 2.0	Yes	GPRS, Edge, 3G (HSPA 42.2/5.76 Mbps), 4G LTE-A, 5G capable, EV-DO Rev.A 3.1 Mbps	Accelerometer, Face ID, Barometer, Compass, Gyro, Proximity	Lightning to 3.5 mm headphone jack adapter, MP3/WAV/AAX+/AIFF/Apple Lossless player, MP4/H.264 player, Speaker Phone	HTML5 (Safari)	iMessage, SMS (threaded view), MMS, Email, Push Email	Built-in + Downloadable	Yes	(Li-ion Non removable), 2227 mAh		up to 50 hrs	Price in Rs: 157,292 Price in USD: $1172	Average Rating is 4.3 stars - basars - based on 11 user reviews.		SA/NSA/Sub6/mmWave	Hexa-core (2 x 3.1 GHz Firestorm + 4 x 1.8 GHz Icestorm)	Apple A14 Bionic (5 nm)	Apple GPU (4-core graphics)	up to 15 hrs
7	Apple iPhone 12 Pro	IOS 14.1	146.7 x 71.5 x 7.4 mm	189 g	Dual Sim, Dual Standby or eSIM (Nano-SIM)	Silver, Graphite, Gold, Pacific Blue	SIM1: GSM 850 / 900 / 1800 / 1900SIM2: GSM 850 / 900 / 1800 / 1900	HSDPA 850 / 900 / 1700(AWS) / 1900 / 2100	LTE band 1(2100), 2(1900), 3(1800), 4(1700/2100), 5(850), 7(2600), 8(900), 12(700), 13(700), 17(700), 18(800), 19(800), 20(800), 25(1900), 26(850), 28(700), 29(700), 30(2300), 34(2000), 38(2600), 39(1900), 40(2300), 41(2500), 66(1700/2100)		Super Retina XDR OLED Capacitive Touchscreen, 16M Colors, Multitouch	6.1 Inches	1170 x 2532 Pixels (~457 PPI)	Scratch-resistant glass, oleophobic coating			No	phase detection, OIS, 2x optical zoom, Geo-tagging, , touch focus, face/smile detection, HDR (photo/panorama), Video (4K@24/30/60fps, 1080p@30/60/120/240fps, 10‑bit HDR, Dolby Vision HDR (up to 60fps), stereo sound rec.)	Dual 12 MP, f/2.2, 23mm (wide), 1/3.6 + SL 3D, (depth/biometrics sensor), HDR, Video (4K@24/30/60fps, 1080p@30/60/120fps, gyro-EIS)	Wi-Fi 802.11 a/b/g/n/ac/6, dual-band, hotspot	v5.0 with A2DP, LE	Yes + A-GPS support, & GLONASS, GALILEO, QZSS	Lightning, USB 2.0	Yes	GPRS, Edge, 3G (HSPA 42.2/5.76 Mbps), 4G LTE-A, 5G capable, EV-DO Rev.A 3.1 Mbps	Accelerometer, Compass, Face ID, Gyro, Proximity	Lightning to 3.5 mm headphone jack adapter, MP3/WAV/AAX+/AIFF/Apple Lossless player, MP4/H.264 player, Speaker Phone	HTML5 (Safari)	iMessage, SMS (threaded view), MMS, Email, Push Email	Built-in + Downloadable	Yes	(Li-ion Non removable), 2815 mAh		up to 65 hrs	Price in Rs: 238,050 Price in USD: $1774	Average Rating is 4.3 stars - basars - based on 50 user reviews.		5G SA/NSA/Sub6/mmWave	Hexa-core (2 x 3.1 GHz Firestorm + 4 x 1.8 GHz Icestorm)	Apple A14 Bionic (5 nm)	Apple GPU (4-core graphics)	up to 17 hrs
8	Apple iPhone 12 Pro Max	IOS 14.1	160.8 x 78.1 x 7.4 mm	228 g	Dual Sim, Dual Standby (Nano-SIM)	Silver, Graphite, Gold, Pacific Blue	SIM1: GSM 850 / 900 / 1800 / 1900SIM2: GSM 850 / 900 / 1800 / 1900	HSDPA 850 / 900 / 1700(AWS) / 1900 / 2100	LTE band 1(2100), 2(1900), 3(1800), 4(1700/2100), 5(850), 7(2600), 8(900), 12(700), 13(700), 17(700), 18(800), 19(800), 20(800), 25(1900), 26(850), 28(700), 29(700), 30(2300), 34(2000), 38(2600), 39(1900), 40(2300), 41(2500), 66(1700/2100)		Super Retina XDR OLED Capacitive Touchscreen, 16M Colors, Multitouch	6.7 Inches	1284 x 2778 Pixels (~457 PPI)	Scratch-resistant glass, oleophobic coating			No	Geo-tagging, touch focus, face/smile detection, HDR (photo/panorama), Video (4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, Dolby Vision HDR (up to 60fps), stereo sound rec.)	Dual 12 MP, f/2.2, 23mm (wide), 1/3.6 + SL 3D, (depth/biometrics sensor), HDR, Video (4K@24/30/60fps, 1080p@30/60/120fps, gyro-EIS)	Wi-Fi 802.11 a/b/g/n/ac/6, dual-band, hotspot	v5.0 with A2DP, LE	Yes + A-GPS support, & GLONASS, GALILEO, QZSS	Lightning, USB 2.0	Yes	GPRS, Edge, 3G (HSPA 42.2/5.76 Mbps), 4G LTE-A, 5G capable, EV-DO Rev.A 3.1 Mbps)	Accelerometer, Barometer, Compass, Face ID, Gyro, Proximity	Lightning to 3.5 mm headphone jack adapter, MP3/WAV/AAX+/AIFF/Apple Lossless player, MP4/H.264 player, Speaker Phone	HTML5 (Safari)	iMessage, SMS (threaded view), MMS, Email, Push Email	Built-in + Downloadable	Yes	(Li-ion Non removable), 3687 mAh		up to 80 hrs	Price in Rs: 297,830 Price in USD: $2219		Average Rating is 4 stars - bases - based on 154 user reviews.	SA/NSA/Sub6/mmWave	Hexa-core (2 x 3.1 GHz Firestorm + 4 x 1.8 GHz Icestorm)	Apple A14 Bionic (5 nm)	Apple GPU (4-core graphics)	up to 20 hrs
9	Apple iPhone 13	IOS 15	146.7 x 71.5 x 7.7 mm	174 g	Dual Sim, Dual Standby or eSIM (Nano-SIM)	Starlight, Midnight, Blue, Pink, Red	SIM1: GSM 850 / 900 / 1800 / 1900SIM2: GSM 850 / 900 / 1800 / 1900	HSDPA 850 / 900 / 1700(AWS) / 1900 / 2100	LTE		Super Retina XDR OLED Capacitive Touchscreen, Multitouch	6.1 Inches	1170 x 2532 Pixels (~457 PPI)	Scratch-resistant ceramic glass, oleophobic coating			No	Video (4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, Dolby Vision HDR (up to XXfps), stereo sound rec.).	Dual 12 MP, f/2.2, 23mm (wide), 1/3.6 + SL 3D, (depth/biometrics sensor), HDR, Video (4K@24/25/30/60fps, 1080p@30/60/120fps, gyro-EIS)	Wi-Fi 802.11 a/b/g/n/ac/6, dual-band, hotspot	v5.0 with A2DP, LE	Yes + A-GPS support, & GLONASS, GALILEO, QZSS	Lightning, USB 2.0	Yes	GPRS, Edge, 3G (HSPA 42.2/5.76 Mbps), 4G LTE-A, 5G, (EV-DO Rev.A 3.1 Mbps)	Accelerometer, Barometer, Compass, Face ID, Gyro, Proximity	Lightning to 3.5 mm headphone jack adapter, MP3/WAV/AAX+/AIFF/Apple Lossless player, MP4/H.264 player, Speaker Phone	Yes	iMessage, SMS (threaded view), MMS, Email, Push Email	Built-in + Downloadable	Yes	(Li-ion Non removable), 3240 mAh		up to 75 hrs			Average Rating is 5 stars - bas - based on 2 user reviews.	Sub6/mmWave	Hexa-core (2 x 3.22 GHz + 4xX.X GHz)	Apple A15 Bionic (5 nm)	Apple GPU (4-core graphics)	up to 19 hrs	Price in Rs: Coming Soon (Expected Rs: 200,49 (Expected Rs: 200,499) Price in USD: $NA
Sheet2

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Insert a new column after each column and populate its value based on the column adjacent to it
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Amir Wisal]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Insert a new column after each column and populate its value based on the column adjacent to it
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thank you Fluff for pointing out, i am new to these forums and was not aware of the forums rules. I will go through the rules in details and will be more cautious next time.

Cheers