Transposing data without redundancy

[drazendrazen]

Hello everyone!

I have an beginner issue, hope its not nerving the more experienced ones between you.

In the attached example, I have the following situation:

Sheet Table1: Each case is made of Case Number, Name, Street, Document Number(s), Postal Code, City, Country name. Some of the cases have multiple Document numbers assigned to it. I would like to transpose the data, so that each column contains the case data, with the Document Numbers for each case listed beneath each other (Sheet Table2).

Fe. Sheet Table1 contains data like Name, Street, Postal Code which have multiple Document numbers attached to it.

I would like to transpose the data so that each case has their Document numbers listed beneath each other, and also minimize the redundancy of the rest of the data (like Case Number, Name, Street etc.) so that each case occurs just once. For example sheet Table2.

Im sorry for the bad explanation.

What would be the best way to do this, especially if the whole data set is bigger with some cases containing f.e. 50 Document Numbers to it?

Thank you!