Forum Discussion
Complex Table Transformation to be used in Power BI
Hello. That looks impossible and I have tried several ways to transform the table below using M code: so that it looks like this structure (below): Does anyone know how to d...
Anonymous - can you upload an sample excel file please? You need to create a couple of Indexes. [A] number that changes every 4 rows, and [B] 1, 2, 3, 4 for the different rows. You can then separate the rows types to transform them. Then eventually merge back together using the Index [A].
Anonymous and KNP of course. here is the sample table. If not, please find attached a link to the table in Excel. Link to the table click here
PRODUCT COMPANY EMPLOYEE COMPANY DIRECTOR COMPANY PRESIDENT A kim lili pedro Full Title Employee of company A Director A President A Date of Appointment 29-Sep-14 PRODUCT COMPANY EMPLOYEE COMPANY DIRECTOR COMPANY PRESIDENT B becky ron peter Full Title Employee of company B Director B President B Date of Appointment 24-Jul-17 15-Sep-13 04-Jan-21 PRODUCT COMPANY EMPLOYEE COMPANY DIRECTOR COMPANY PRESIDENT C ted ben john Full Title Employee of Company C Director C President C Date of Appointment 19-Dec-19 Anonymous thank you very much!!