Forum Discussion

sds87's avatar
sds87
Copper Contributor
Mar 09, 2023

Reformat Data Table

I need to take a typical database table with business contact information and filter it so each row contains the business name, address, etc. and all contacts for each business address are listed on the same row. Current format is business name, address, etc. with a single contact per row with approximately 2,400 entries.

Current Format:

 

 

 

Desired Format:

Thanks for the help.

excel
Formulas and Functions

4 Replies

  • ricardojose's avatar
    ricardojose
    Brass Contributor
    Mar 09, 2023
    You are looking for a pivot table there! Would you mind uploading your file so I can create the solution for you?

    Thanks!
    • sds87's avatar
      sds87
      Copper Contributor
      Mar 09, 2023

      ricardojose 

      Thank you. Here is a link to the file: https://netorgft12506003-my.sharepoint.com/:x:/g/personal/ssnow_bts-gc_com/EaWzsstBDkJLjWEw1KaFgQcBuE8PAVoq8Vfgel_n9Yxr6g?e=UPJ9Qu

      • ricardojose's avatar
        ricardojose
        Brass Contributor
        Mar 09, 2023
        After seeing what you want to achieve I will tell you that that is against all the databases norms that exist. Are you wanting to have that because a third-party system requires the data to be in that way? Or do you need it to create an internal report? Sorry for asking that, but I think it will give me more context and I will be be able to give you a better advice.