Forum Discussion

DMOV's avatar
DMOV
Frequent Visitor
4 years ago

Convert column records to rows records

¡Hello everyone!

 

I have multiple tables which I extract to pipedrive CRM in JSON format. When I try to expand the records (that are related to other ID objects), they are displayed in columns and not in rows.

 

Do you have any idea if this can be fixed with upivot columns or other solutions?

 

Steps to reproduce:

1: Column referred to the "organization" table:

2: Click expand into new columns:

 

3: Expanded view:

 

Issue: I need the object details (highlighted numbers) to be displayed in rows, not columns.

Thanks in advance!

Need Help
Tips and Tricks

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    4 years ago

    Hi DMOV 

     

    You could select the columns then Unpivot them.  But you'll likely end up with nulls all over the place.

     

    It would be better if we knew what data was in those records and exactly how you want the final table to look.

     

    Can you please supply some sample data and an example of your desired result.

     

    Regards

     

    Phil