![]() While this is a really old question and Stefan found an enlightened answer back in the day, it could be worth a revisit. However, that requires I change the table-create script and the unpivot-script for every change in groups. in SQL I could do it like this: CREATE TABLE dbo.T_DocumentMatrixĬopy-paste the data from excel, and then SELECT * ![]() Into this half-normalized table (so I can insert it into a SQL database):Į.g. I need to convert this permission matrix (given as Excel-table/matrix) I want to know if it is possible to do it without code, quickly ?Į.g. ![]() ![]() ![]() Is there a quick way to "unpivot" an Excel matrix/pivot-table (in Excel or elsewhere), without writing macros or other code ?Īgain, I can write code (C# or VBA or whatever) that does that myselfs. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |