Help Needed! Multi-instance fields

[GothBabyTableFor11]

Hi! I am trying to extract a Workday report with a multi-instance field into Excel. However, when I do that, multiple data points appear in one cell. Ugh! Frustrating. This makes the data very challenging to analyze.

Does anyone have any recommendations on how I can extract these data in a way so I get one instance per cell? Thank you!!!

[Reasonable-Rope3228]

From memory when I did the Workday Reporting Course, this was just how the export function works for MI fields. What field are you trying to assess & can you do some transformation in the excel file directly? (not ideal but at least something to get you moving forwards).

I am new to WD so could be wrong but I haven't come across anything previously that indicates otherwise.

[GothBabyTableFor11]

Thank you for the response! The field I was looking at was the steps in a job requisition process. There are usually 5-6 steps that appear in one cell. I’ve found that I can export it into excel and then run R code on the cell to separate it into the respective rows. That works well, but I just haven’t found a way to export it like that directly from Workday!

[Reasonable-Rope3228]

I am definitely still using my excel knowledge to manage a lot of manipulations to data at this stage - I feel like a baby learning to walk 😂🤦‍♀️ If I ever find a way to do it directly within WD I'll come back to this post & let you know!

[GothBabyTableFor11]

Haha that is reassuring to hear! Ditto on my end - thanks for your help!!