I am stuck on a tricky Pivot

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

Pivot Demo.xlsx

Transformation

Accepted answers

JosephSerpis

Hi @Jtunner have updated the flow to remove the nulls. If you found this post useful could you mark it as solved please?

Pivot.yxzp

All comments

LordNeilLord

Hey @Jtunner

Have you tried the transpose tool?

Group on Product, Supplier, Customer, Status & Ship Date

neilgallen

In situations like this it’s best to show what your desired output would be. That’s the best way to know how to help.

JosephSerpis

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.

Pivot.yxzp

Jtunner

I have, I am just get stuck pretty easily. Big learning curve for me. Thank you!

Jtunner

Basically, I am trying to makes the dates vertical, and determine who checked what on which date.

Jtunner

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703