You have a Microsoft 365 subscription.
From the subscription, you perform an audit log search, and you download all the results.
You plan to review the audit log data by using Microsoft Excel.
You need to ensure that each audited property appears in a separate Excel column.
What should you do first?
A . From Power Query Editor, transform the JSON data.
B . Format the Operations column by using conditional formatting.
C . Format the AuditData column by using conditional formatting.
D . From Power Query Editor, transform the XML data.
Answer: A