cross tab

Hi I have summarized data in the following format: 2021 2022 2023 admin 1 2 2 I would like to convert this so it is presented as: admin 2021 admin 2022 admin 2022 admin 2023 admin 2023 I've tried PowerPivot and the Unpivot option. That doesn't seem to show in this...

hi all, I have two tabs: DATA1 and DATA2 as followed: DATA1 ------- <tbody> ID VAL1 VAL2 1 1 2 1 3 4 1 5 6 2 7 8 2 9 10 2 11 12 3 13 14 </tbody> DATA2 ------- <tbody> ID NAME 1 john 2 eric 3 paul </tbody> Using the unique ID column which linked the data in the two...

Keep getting close, just not quite yet. I have the following cross tab table that I would like to convert to a flat file. (pivot table ready) The labels that begin w/ > will not contain data, but will be needed as metric labels for the data below each one. As long as I keep these headings out...

I have a manually created crosstab that I want to convert to a series of lists. Here is the example: TABLE: Class1 Class2 Class3 Name1 1 Name2 1 Name3 1 Name4 1 1 RESULTS Class1 Class2 Class3 Name1 Name3 Name2 Name4 Name4 I would like to have the bottom section automatically...

I have a list with students down the side, classes across the top and a "1" at the intersection - where a student decided to take the class. The spreadsheet uses the 1 and an associated price per class to calculate total cost per student, etc. Is there an easy way to create a list off this of...