mifusion to excel

Thanks for reaching out!

 
While MiFusion exports the job status data into a single column by default, you can easily transform this in excel using a Pivot Table. This will allow you to display each unique job status.

 
1. Export Data from MiFusion:

                       1. Export your data from MiFusion as excel or CSV                      
 2. Open it in Excel.                      
  3. Ensure there's a column named something like Job status and another identifier like Job ID.

2.Use Pivot Table (Recommended method):

      1. Select your data including Job ID and Job Status.

      2. Go to Insert -> Pivot table.

      3. In the Pivot table:

• Drag Job ID to the Rows area.
•  Drag Job status to the columns area.
•  Drag Job status again to the values area.

 4. By default, Excel will do a count of each job status per Job ID - exactly what you need.

5. You can then:  Replace counts with a checkmark or "yes" using a formula -> Format as needed.

If you face any issues during this process, feel free to reach out for more specific guidance.

If you find this helpful, please mark the response as "answered".