View or Export Subfields of Address field

View or Export Subfields of Address field

Hi, I hope this is straight forward, but haven't been able to quickly find an answer.
I need to export the (new) Name and Address fields as their corresponding subfields.

So Prefix, First Name, Last Name, Address line 1, Address Line 2 etc in separate fields. This is required for the Mail merge software my client is using.

I can tell each subfield is stored separately, because you can search in them or choose which ones to display.
And in a report you can choose which subfield(s) to show, but only once, you cannot pick the same Field twice and then choose for each a different subfield to show.
 
    Zoho Marketing Automation
      Zoho Mail - CRM Integration

              Zoho Pagesense Resources

                Zoho SalesIQ Resources



                      Zoho TeamInbox Resources

                        Zoho DataPrep Resources



                          Zoho CRM Plus Resources

                            Zoho Books Resources


                              Zoho Subscriptions Resources

                                Zoho Desk Resources

                                  Zoho Projects Resources


                                    Zoho Sprints Resources


                                      Qntrl Resources


                                        Zoho Creator Resources


                                          Zoho WorkDrive Resources




                                              Zoho Campaigns Resources

                                                Zoho CRM Resources

                                                        Design. Discuss. Deliver.

                                                        Create visually engaging stories with Zoho Show.

                                                        Get Started Now