Forum Discussion

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 ...

excel

Formulas and Functions

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

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
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.
- sds87
  Copper Contributor
  Mar 10, 2023
  A third-party system has that format.