Advanced transposing of data

[Exc3lnoob]

Hi! I have a problem, I need to transpose a lot of data and I cannot find a standard way to do it.

Current structure:
Skärmavbild 2018-04-16 kl. 15.09.24.png

Desired structure:
Skärmavbild 2018-04-16 kl. 15.16.21.png

Thank you!

[sandy666]

Attach a sample workbook (not a picture!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[MarvinP]

Hi Exc3lnoob and welcome to the forum,

Look at the UnPivot Tool in Get & Transform.

https://support.office.com/en-us/art...5-f588221c7098
https://trumpexcel.com/unpivot-data/

[Exc3lnoob]

Here is a sample workbook

[sandy666]

is that what you want?

[Exc3lnoob]

I can't open your file, I'm working from a mac and I guess I can'y use PQ...

[sandy666]

Ops! Sorry
Update your profile about word Mac

[Exc3lnoob]

I now changed computer and the file you attached is exactly what I'm looking for, how did you do it?

I worked it out, thank you!!!

[sandy666]

Good choice

long story or short story?

[MarvinP]

Hi Exc3lnoob,

Open the file sandy give you and click on the Data Tab and then on the "Queries and Connections" Icon. That will bring up the right side queries. Hover over the one query and click on Edit. It will show what sandy did.

If you look at it in the Advanced Editor it looks like:

Please Login or Register  to view this content.

BUT - it is much easier to do than writing the code above. He did an UnPivot Other Columns. Read about it at:

https://excel.tv/unpivot-power-query/

[sandy666]

I c u got an answer without my participation

so

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.