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