Sudhir Prabhu
Member
Folks,
A question on the Unpivot in Power query. Is it possible to link two or more related columns to Unpivot together ?
Scenario is, I have two columns - say there is a milestone called "Installment 01"; the data I have is in two columns - "Installement 01 Date" (due date) and ""Installement 01 Amount".
I achieved a messy (really messy!) workaround by concatenating the two columns, unpivoting, and then separating the concatenated columns into two. But that is like going around the moon to fly Bangalore to LA !!
Any better thoughts ? (Can wait - enjoy your weekend !
) Attached a sample data.
Cheers!
Sudhir
A question on the Unpivot in Power query. Is it possible to link two or more related columns to Unpivot together ?
Scenario is, I have two columns - say there is a milestone called "Installment 01"; the data I have is in two columns - "Installement 01 Date" (due date) and ""Installement 01 Amount".
I achieved a messy (really messy!) workaround by concatenating the two columns, unpivoting, and then separating the concatenated columns into two. But that is like going around the moon to fly Bangalore to LA !!
Any better thoughts ? (Can wait - enjoy your weekend !
Cheers!
Sudhir