= unstack.xlsx30 KB If you don't already have the blue dynamic table then select a cell in the range and create the dynamic table with ctrl+T. Then you can start the Power Query Editor like shown in the screenshot. Now you see the Power Query Editor where you can pivot the data. ...
excel Like 0 Reply OliverScheurich to NikeMikeApr 02, 2023 NikeMike =COUNTIF($A$2:A2,"Name und Autor") An alternative could be Power Query along with a helper column with this formula. In the attached file you can add data to the blue dynamic table. Then fill the formula down from...
I have an excelsheet with two columns of data. In the first Column there are the units "Name", "Date", "Code", "Storage", "Origin" and sometimes "Descrption" and or "Place". In the second column, there is the corresponding data. Now I would like to unstack the two columns so t...
"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-04-01T10:07:21.355-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0},"ForumTopicMessage
[]}}},"eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/"},"ForumTopicMessage:message:3785233":{"__typename":"ForumTopicMessage","uid":3785233,"subject":"Unstack data from a double column","id":"message:3785233","revision...