Tranforming Data - Rows to Columns

[Kristie_Pires]

Hello there,

How would you transform the data from the first table to the data on the second table? Whenever a loan has more than one guarantor, the guarantor name and ID should be displayed in another column. 

Loan ID	Customer Name	Guarantor Name	Guarantor ID
A	Mary	Peter	xxxx-11
B	James	May	xxxx-12
B	James	Lara	xxxx-13
C	Anna	Ryan	xxxx-14
C	Anna	John	xxxx-15
C	Anna	Chris	xxxx-16

Loan ID	Customer Name	Guarantor Name 1	Guarantor Name 2	Guarantor Name 3	Guarantor ID 1	Guarantor ID 2	Guarantor ID 3
A	Mary	Peter			xxxx-11
B	James	May	Lara		xxxx-12	xxxx-13
C	Anna	Ryan	John	Chris	xxxx-14	xxxx-15	xxxx-16

[TimN]

[TimN · Accepted solution]

Here's a more complete one.

[PanPP · Accepted solution]

Hi @Kristie_Pires 

One way to accomplish this.

[ArtApa · Accepted solution]

Hi @Kristie_Pires - Here is a dynamic solution for you:

[Kristie_Pires]

Thank you all for helping me out! I always struggle with the Cross Tab and Transpose tool 😅