ContributionsMost RecentMost VotedSolutionsTranspose every 5 rows into Column Hi there, I am writing in to seek guidance. I would like to perform the following. Before: Result: Thank you SolvedUnpivot Rows to Column Dear All I would like to know if the following is possible? I would have a large set of data and the number of columns depends on the no. of rows the data appears. Some can be 1, 2, 3, 4 or 5 columns. Thank you in advance! Data Unique Reference Column 2 2404124231223097 TMPN 2404124231223097 3770808102FS 2404124231223080 9135793102FS 2404124231223085 REPAYMENT 2404124231223085 /BOOK 2404124231223085 3254675102FS 2404124231223084 USD10 2404124231223084 REPAYMENT 2404124231223084 039190 2404124231223084 1447267102FS 2404124231223094 BORROWING 2404124231223094 //BASE 2404124231223094 5971952102FS 2404124231223094 /ACC 2404124231223094 00005ILC240004 Result Unique Reference Column 1 Column 2 Column 3 Column 4 Column 5 2404124231223097 TMPN 3770808102FS 2404124231223080 9135793102FS 2404124231223085 REPAYMENT /BOOK 3254675102FS 2404124231223084 USD10 REPAYMENT 039190 1447267102FS 2404124231223094 BORROWING //BASE 5971952102FS /ACC 00005ILC240004 Solved
Data PrivacyMicrosoft Fabric Community and Privacy To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide. Read the guide
