Issue - Pivot/ Unpivot Scenario

Question

Hi All,I want to change below data&nbsp;&nbsp;FixVersion&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Stage&nbsp; &nbsp; &nbsp; &nbsp;StageStatusSFP.R.11.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CompletedSFP.R.11.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CompletedSFP.R.11.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; In ProgressSFP.R.11.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Not StartedSFP.R.11.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CompletedSFP.R.11.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CompletedSFP.R.11.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; In ProgressSFP.R.11.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Not Started&nbsp;to like belowFixVersion&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SFP.R.11.8&nbsp; &nbsp; &nbsp; &nbsp; Completed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Completed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;In Progress&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Not StartedSFP.R.11.9&nbsp; &nbsp; &nbsp; &nbsp; Completed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Completed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;In Progress&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Not Started&nbsp;help me out here..&nbsp;&nbsp;

beabf · Accepted Answer

KR300&nbsp;Hi! Here the power query code:letSource = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCnYL0AvSMzTUs1BQ0lFyVAACIO2cn1uQk1qSmqIUq4OuxokINc5QNZ55CgFF+elFqcXFWFS5QFX55ZcoBJckFmGYZUmEmyyJcJMlUW6yxOmmWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"FixVersion " = _t, Stage = _t, StageStatus = _t]),#"Changed Type" = Table.TransformColumnTypes(Source,{{"FixVersion ", type text}, {"Stage", type text}, {"StageStatus", type text}}),#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type", {{"Stage", type text}, {"StageStatus", type text}}),List.Distinct(#"Changed Type"[Stage]),"Stage","StageStatus")in#"Pivoted Column"from:&nbsp;you'll obtain:&nbsp;if it's ok, please accept my answer as solution!&nbsp;BBF

Forum Discussion

Issue - Pivot/ Unpivot Scenario

2 Replies

Related content

Pivot / Unpivot?

Pivot\Unpivot

Unpivot/Pivot

Pivot unpivot Timestamp Values

Unpivot Column