Forum Discussion
Date rows as columns
Hi everyone, I have a table with 2 different date columns: "as of date", "prod. date". It also contains a first column with multiple clients and columns for different types of products, as shown ...
Ashish_Mathur
Super User
Super UserHi,
Share your desired Table structure.
Hi Ashish_Mathur , please find below the link for the table structure.
https://drive.google.com/open?id=1BjPfE6Vf2Hp8-MEjQLrNzDHBXu6vU6mn
Since I will do multiple calculated columns, the desired table looks something like this, filtering for Product Type 1A. The dates shown as columns, are the ones from "as of date" field.
Thanks for checking!
- Ashish_Mathur
Thank you Ashish_Mathur ! The method provided worked for me!