Copy data and paste them in slightly different structure

JayGatsby

New Member
Joined
Apr 27, 2020
Messages
7
Office Version
  1. 2019
Platform
  1. Windows
Hi fellow Excel fighters ?

I’m facing a little challenge where I am trying to achieve a copy/paste of data from one column to another while slightly altering the original structure.
This should be done in the whole column range (e.g. B:B or C:C)

Kindly see the example for better understanding.

Much appreciated!
 

Attachments

  • Jay.PNG
    Jay.PNG
    36.8 KB · Views: 11

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Cannot manipulate data in a picture. Please use XL2BB to upload your sample data so that we can understand all. You reference in your picture particular columns but the columns are not identified in the picture. Use XL2BB.
 
Upvote 0
Jay.xlsx
ABCD
1
2Original
3TEAMSDETAILSNUMID
4T1;T3[O NAS] info1. [Detail] Fact. [Detail2] Fact. N1*N2*N3*N4{S1}ADD1;{S2}22;{S3}12;{S4}21;{S5}321;{S6}ADD2;{S7}77;{S10}ADD3
5T4;T2;T6;T7[O NAS] Fact7. [Detail] Fact. [Detail2] Fact. N5*N6*N7{S1}ADD1;{S2}22;{S3}12;{S4}21;{S5}321;{S6}ADD2;{S7}77;{S10}ADD3
6
71) IF ID field (column D) = {S1} or {S6} or {S10} then add the respective number IN "{}" at the end of TEAMS field separated with ";": e.g. T1;T3;ADD1;ADD2;ADD3.This should be done for all the cells in column D (and A)
8
92) COPY content of Column "C(n) on the top of existent content of the column B(n) while adding the heading of the column as a constant for all inputs in "[]"; e.g. [NUM - N5, N6, N7]. This should be done for all the cells in column C (and B)
10
11The above should just add selected content of columns "D" AND "C" to "A" and B", without deleting anything from columns "D" & "C"
12
13Desired outcome
14TEAMSDETAILSNUMID
15T1;T3;ADD1;ADD2;ADD3[NUM - N1, N2, N3, N4]. [O NAS] info1. [Detail] Fact. [Detail2] Fact. N1*N2*N3*N4{S1}ADD1;{S2}22;{S3}12;{S4}21;{S5}321;{S6}ADD2;{S7}77;{S10}ADD3
16T4;T2;T6;T7; ADD1;ADD2;ADD4[NUM - N5, N6, N7]. [O NAS] Fact7. [Detail] Fact. [Detail2] Fact. N5*N6*N7{S1}ADD1;{S2}22;{S3}12;{S4}21;{S5}321;{S6}ADD2;{S7}77;{S10}ADD4
Sheet1
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,103
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top