Insert

[SOLTEC]

I have a spreadsheet with POS SKU numbers and I want to create two rows below each SKU with the same SKU number with one adding cc to the end of the SKU and inserting it before the original SKU, and then below that another original SKU with the same original SkU with c concatenated for 1,000's a SKU for my POS system.

 

[awoohaw]

your image has B and not a C, what do you mean by 1000s?

 

[awoohaw]

Here it is done in another column:

(edited 2 min after posting):

Book1
	A	B
1
2	CM3671	CM1740
3	CM7882	CM1740B
4	CM6670	CM1740cc
5	CM6432	CM1754
6	CM2539	CM1754B
7	CM1740	CM1754cc
8	CM9408	CM1903
9	CM9263	CM1903B
10	CM8645	CM1903cc
11	CM1903	CM2539
12	CM6030	CM2539B
13	CM8144	CM2539cc
14	CM1754	CM2797
15	CM3920	CM2797B
16	CM7838	CM2797cc
17	CM2797	CM3671
18	CM5077	CM3671B
19	CM7288	CM3671cc
20	CM5872	CM3920
21	CM8045	CM3920B
22	CM8916	CM3920cc
23		CM5077
24		CM5077B
25		CM5077cc
26		CM5872
27		CM5872B
28		CM5872cc
29		CM6030
30		CM6030B
31		CM6030cc
32		CM6432
33		CM6432B
34		CM6432cc
35		CM6670
36		CM6670B
37		CM6670cc
38		CM7288
39		CM7288B
40		CM7288cc
41		CM7838
42		CM7838B
43		CM7838cc
44		CM7882
45		CM7882B
46		CM7882cc
47		CM8045
48		CM8045B
49		CM8045cc
50		CM8144
51		CM8144B
52		CM8144cc
53		CM8645
54		CM8645B
55		CM8645cc
56		CM8916
57		CM8916B
58		CM8916cc
59		CM9263
60		CM9263B
61		CM9263cc
62		CM9408
63		CM9408B
64		CM9408cc
Sheet1

Cell Formulas
Range	Formula
B2:B64	B2	=SORT(TOCOL(TEXTSPLIT(TEXTJOIN(",",,A2:A22 &"cc",A2:A22,A2:A22 &"B"),",")))
Dynamic array formulas.

 

[awoohaw]

It keeps the SKU together, but it rearranges alpha-numerically.

 

[fjns]

Hi, see the linked file for a possible solution...

The formula used in the table:
=LET(x,INDEX(A:A,INT((ROW()+4)/3)),y,MOD(ROW()+4,3),IF(x="","",IF(y=0,x,x&IF(y=1,"CC","B"))))

SKUinsert.xlsx

 

[Fluff]

Another option

Fluff.xlsm
	A	B
1
2	CM3671	CM3671
3	CM7882	CM3671CC
4	CM6670	CM3671B
5	CM6432	CM7882
6	CM2539	CM7882CC
7	CM1740	CM7882B
8	CM9408	CM6670
9	CM9263	CM6670CC
10	CM8645	CM6670B
11		CM6432
12		CM6432CC
13		CM6432B
14		CM2539
15		CM2539CC
16		CM2539B
17		CM1740
18		CM1740CC
19		CM1740B
20		CM9408
21		CM9408CC
22		CM9408B
23		CM9263
24		CM9263CC
25		CM9263B
26		CM8645
27		CM8645CC
28		CM8645B
29
Data

Cell Formulas
Range	Formula
B2:B28	B2	=LET(f,FILTER(A2:A100,A2:A100<>""),MAKEARRAY(ROWS(f)*3,1,LAMBDA(r,c,INDEX(f,INT((r-1)/3)+1)&CHOOSE(MOD(r-1,3)+1,"","CC","B"))))
Dynamic array formulas.