Hello!
I have attached a demo table for product inspections. The inspection dates are used as headers, and if an inspection was performed on that date, the inspector's name is in that date column. I need help fixing this.
Thank you in advance!
Jonathan
Solved! Go to Solution.
Hey @Jtunner
Have you tried the transpose tool?
Group on Product, Supplier, Customer, Status & Ship Date
Hi @Jtunner do you have an example of the format you are trying to achieve? I mocked up something assuming you want dates in a vertical format rather than horizontal.
I have, I am just get stuck pretty easily. Big learning curve for me. Thank you!
Basically, I am trying to makes the dates vertical, and determine who checked what on which date.
JS420,
That is what I am going for. I assume once that is done, we would get rid of the null values so that we can save space?
Jonathan
Hi @Jtunner have updated the flow to remove the nulls. If you found this post useful could you mark it as solved please?