Transposing Data Efficiently

[JansiJansi]

Hi!

Problem: I have two SKUs (col B) per Code (col A). I need to somehow transpose the data efficiently so that it is in the desired format. Each only has 2, so I don't need to make it dependent on the Code.

Current Data:

Book1
	A	B
2	B003TQM9VA	6D-BZDA-DVVY
3	B003TQM9VA	YG-TJYH-O0G2
4	B003TQM9XS	EK-19SU-5H0H
5	B003TQM9XS	6B-KVK8-8250
6	B003UW8O4Y	FF-1K7C-RZQQ
7	B003UW8O4Y	SD-D1N8-Y5LK
Sheet1

Desired Format:

Book1
	D	E
1	Parent Search Term	Alternate SKU
2	6D-BZDA-DVVY	YG-TJYH-O0G2
3	EK-19SU-5H0H	6B-KVK8-8250
4	FF-1K7C-RZQQ	SD-D1N8-Y5LK
Sheet1

Here's what I have been doing (warning: cringe): Help Me Excel Gods.webm

I've tried pivot tables, and can't get it to display each SKU in a new column by Code.

Thank you in advance!

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1
2	B003TQM9VA	6D-BZDA-DVVY		6D-BZDA-DVVY	YG-TJYH-O0G2
3	B003TQM9VA	YG-TJYH-O0G2		EK-19SU-5H0H	6B-KVK8-8250
4	B003TQM9XS	EK-19SU-5H0H		FF-1K7C-RZQQ	SD-D1N8-Y5LK
5	B003TQM9XS	6B-KVK8-8250
6	B003UW8O4Y	FF-1K7C-RZQQ
7	B003UW8O4Y	SD-D1N8-Y5LK
8
Main

Cell Formulas
Range	Formula
D2:E4	D2	=WRAPROWS(B2:B7,2)
Dynamic array formulas.

 

[JansiJansi]

Fluff... I love you lol. Thank you so much.

There's always a super simple way that I just didn't know about!

 

[Fluff]

Glad to help & thanks for the feedback.

 

[JansiJansi]

Glad to help & thanks for the feedback.

Is there a way to do this for other amounts of duplicates? The formula is designed for 2, but can it work with 3, 4, 5+, etc.?

The problem is the result must be constrained to two columns. So:

Used Book Depot.xlsx
	A	B
1	Parent Search Term	Alternate SKU
2	21.28_1071109_20210911_20722
3	25.20_1092348_20210911_18271
4	33.70_368803_20210911_K-10_15
5	09-06-2022_FN_536K_300B27
6	34.99_393517_20210911_17644
7	42.00_741456_20210911_11800
Sheet11

would be

Used Book Depot.xlsx
	A	B
1	Parent Search Term	Alternate SKU
2	21.28_1071109_20210911_20722	25.20_1092348_20210911_18271
3	21.28_1071109_20210911_20722	33.70_368803_20210911_K-10_15
4	09-06-2022_FN_536K_300B27	34.99_393517_20210911_17644
5	09-06-2022_FN_536K_300B27	42.00_741456_20210911_11800
Sheet11

It takes the first of the 3, then puts the other 2 in the column next to it. Seems a bit too complicated but figured I'd ask!

 

[Fluff]

As this is a totally different question, it needs a new thread. Thanks