This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How do i convert data in the following format
Solution is attached.
By filtering for the name column and then appending it back to the transformed data, it's possible to convert the data.
However, if you have multiple IDs within your dataset then you can flag the 3 rows for each ID (Amount, Spread, Deferment) and join back on the ID number.
Both scenarios are mocked up in the attached workflow
Hi @aCha1120 With a little transpose magic!!
Transposing makes the data vertical, which allows us to rearrange. The formula tool fills in "ID" for the heading for column 1, and the company name for the rows where it will otherwise be blank.A Make Columns tool builds the table again, and they Dynamic Select selects only the Value columns.
Dynamic rename to fix the names.
Let me know if that helps.