Excel Power Query to get all custom fields in separate columns, not rows
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?
Hi Stefan Jung , thanks for reaching out!
It looks like your question focuses on Excel rather than Wrike API, and I am afraid we don't have the info on that. So I could totally recommend checking it with Microsoft Support on how to expand the data record.
Let us know if there's anything else we could assist you with.
Darina Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Darina Wrike Team member Become a Wrike expert with Wrike Discover
Thank you for your reply anyway, Darina.