521624_en-US

liliconcom

How do I copy and paste a value based on another column condition

hi,

I want to copy the first row string and paste to all row of the net name column if they have the same group as the group 1 on the sample below

 

thanks,

 

group	pin type	Pin	net name
1	U4	31001	1_BUMP_LKG_FH
1	U5	31001	1_BUMP_LKG_FH
1	U3	46997	1_BUMP_LKG_FH
1	U1	46997	1_BUMP_LKG_FH
1	U2	46997	1_BUMP_LKG_FH
2	U2	46840	2_BUMP_LKG_1_FH
2	U2	46999	U2_2_BUMP_LKG_1_LINK1
2	U3	46840	2_BUMP_LKG_1_FH
2	U3	46999	U3_2_BUMP_LKG_1_LINK1
2	U1	46840	2_BUMP_LKG_1_FH
2	U1	46999	U1_2_BUMP_LKG_1_LINK1
3	U2	46886	2_BUMP_LKG_2_FH
3	U2	46732	U2_2_BUMP_LKG_2_LINK1
3	U3	46886	2_BUMP_LKG_2_FH
3	U3	46732	U3_2_BUMP_LKG_2_LINK1
3	U1	46886	2_BUMP_LKG_2_FH
3	U1	46732	U1_2_BUMP_LKG_2_LINK1
4	U2	46884	3_BUMP_LKG_1_FH
4	U2	46998	U2_3_BUMP_LKG_1_LINK1
4	U2	46839	U2_3_BUMP_LKG_1_LINK2
4	U3	46884	3_BUMP_LKG_1_FH
4	U3	46998	U3_3_BUMP_LKG_1_LINK1
4	U3	46839	U3_3_BUMP_LKG_1_LINK2
4	U1	46884	3_BUMP_LKG_1_FH
4	U1	46839	U1_3_BUMP_LKG_1_LINK2
4	U1	46998	U1_3_BUMP_LKG_1_LINK1

Data AccessData Blending and CleanupQuality and Process EngineeringRe: How do I copy and paste a value based on another column condition

Great! It works. Thanks for a quick help.

Re: How do I copy and paste a value based on another column condition

Is this the table you want?

There are many ways of doing this, one would be to use formula. Here is one example formula:

:"net name"n[Col Min(Row(), :group)]

It uses Col Min to get first row for each group, and then uses that found row to get value from net name column.