how to change multiple, uniquely-named columns to rows?

jenniferallen

Hello, I'm new here and don't really know how to ask this, but I have a spreadsheet with multiple columns that I want to change to rows, but not summing or concatenating the data. Instead I want a new row for each different product, something like:

ORIGINAL:
	PRODUCT 1	PDT NAME 1	INFO 1	PRODUCT 2	PDT NAME 2	INFO 2
GROUP A	A1	AA1	AAA1	A2	AA2	AAA2
GROUP B	B1	BB1	BBB1	B2	BB2	BBB2
GROUP C	C1	CC1	CCC1	C2	CC2	CCC2

and I'm trying to get it to the below

WANT TO CHANGE TO:
	PRODUCT	PDT NAME	INFO
GROUP A	A1	AA1	AAA1
GROUP A	A2	AA2	AAA2
GROUP B	B1	BB1	BBB1
GROUP B	B2	BB2	BBB2
GROUP C	C1	CC1	CCC1
GROUP C	C2	CC2	CCC2

but am completely stuck. I think it's possible but could be wrong any help or insights would be appreciated! Thank you!

SPetrie

Without seeing how your actual columns are named, its a bit difficult to give a full answer.

I took a stab at it assuming that the names are all the same, but with varying numbers associated with them ( Name 1, Name 2, etc) and normalized them by removing the numbers.

Even if this doesnt 100% solve your issue, I hope it at least gets you started in the right direction.

example.yxmd