Yev Kol Posted March 19, 2020 Posted March 19, 2020 I have data that is organized by dates in columns. Tried using transformation but works only for 1 category.. How can I unpivot columns for 2 categories and keep the same date alignment See below: Current: ID Description 1/1/2020 monthly 1/1/2020 Total 2/1/2020 monthly 2/1/2020 Total z1 A 3.13 7154.72 2.84 7157.56 z2 B 3.31 10440.21 2.99 10443.2 z3 C 0 4628 0 4628 z4 D 3.13 5259.68 2.84 5262.52 Needed Transformation: ID Description Date monthly Total z1 A 1/1/2020 3.13 7154.72 z2 B 1/1/2020 3.31 10440.21 z3 C 1/1/2020 0 4628 z4 D 1/1/2020 3.13 5259.68 z1 A 2/1/2020 2.84 7157.56 z2 B 2/1/2020 2.99 10443.2 z3 C 2/1/2020 0 4628 z4 D 2/1/2020 2.84 5262.52
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now