Forum Discussion
Solved
Transpose or Unpivot
Hello, I have a file Co Name, Amount and Date are all in separate columns. I want: Date to be transposed to rows but keep the Co Name and Amount in rows But Group co name. I am not sur...
try this (my) last guess!
Is this what you want for output from your posted file (obviously with more columns and rows)?
If so, it's just a matter of
- delete the unwanted columns
- Pivot on the Date column
- Values = Amt
- No aggregation
Hi ronrsnfld, yes I think that is what I want. I did not know it was that simple. I was over thinking I think. thank you very much for the explanation.