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 · Accepted solution]

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.

[ChrisTX]

Try the attached workflow

Chris

[jenniferallen]

Thank you! This definitely helps a ton, not only what I'm trying to do but also in my understanding. Much appreciated!

[jenniferallen]

Thank you so much! It did not even occur to me to use the union tool for this, great idea! Unfortunately, I have close to 300 columns, in groups of 7, so that's a lot of filter tools however this is great and I have other uses for it. Much appreciated!