How to rearrange some values in rows in to columns

[kiriup]

Hi I don’t have much experience in calc and would like to know if there is an automated way to rearrange the values in my worksheet. I am attaching a picture to show what I need to do.

Basically on each row I have a product code followed by 3 different prices and I would like to rearrange it so that all prices are in the same column. This means that each product code will need to be listed 3 times and the “price number” be listed next to each “price value” in a new column.

I believe the picture that I am attaching will explain what I want to do better. I cant really do this manually for all entries because I have thousands of them!

[LeroyG]

With “automated”, do you mean “one click”? Or are you ready to follow a few steps?

[kiriup]

Hi, sorry “automated” wasn’t the right word for it. I was trying to use the word as opposite to manually doing it line by line. Of course i am willing to follow steps, that would be ideal.
Even if you just point me to the right direction of which functions (or something else?) i should use i would really appreciate it! I can do my research and try to learn how to use them.

[LeroyG]

Move (one, then other) columns labeled 2 and 3 below column 1, then copy first three columns (Code to Unit) and paste them twice below (next to new pasted columns 2 and 3).
To add the 1, 2 and 3 in rightmost column, select the first range, type 1, press Alt+Enter. Repeat for 2 and 3.
Sort.

[kiriup]

Omg thank you, yes its so simple and easy i cant believe i couldn’t think of it myself!

Right before this i was working for a week on a much more complicated project that required a ton of functions like index match if and or and my brain was stuck there. So i was completely overthinking it, trying to do this with functions.
Thanks again this is what i needed!