You can easily use Excel Power Query to transpose a data-set with multiple row headers from multiple columns to rows. Find out how in this quick tutorial.
Switch Data in Columns to Rows Transpose or Unpivot (Some) Fields This will be another tutorial on transposing horizontal data into vertical data. But this technique has a twist. No, wait! TWO twists! Twist 1: we don’t want to change ALL the