I am experimenting with Excel Power Query and the Wrike API. I am very impressed, it works really nice. The only thing I failed to do is to get custom fields into separate columns, not rows. With my current query, Excel generates me a row per custom field, so I get a lot of redundant data in my Excel sheet.
I want to have only a single row per Wrike task and one column per custom field. But I could not figure out how to correctly expand the data record.
Could you please take me by the hand?
Folllowing List for Post: Excel Power Query to get all custom fields in separate columns, not rows
[this list is visible for admins and agents only]