8/31/2023 0 Comments Unpivot add in for mac excelPress F2 on that cell and try again.ĭon't type the curly brackets yourself - it won't work. You do not use CTRL+SHIFT+ENTER you will (almost always) get an error Those of you in India - appear around the outside of your formula. "curly braces" for those of you in the USA, or "flower brackets" for You will know the array is active when you see curly brackets - or They MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the =IF(G2="","",-TRIM(MID(SUBSTITUTE(","&VLOOKUP(G2,$A$2:$B$5,2,FALSE),",",REPT("Īrray Formulae are a little different from ordinary formulae in that Re: Formula to unpivot data You need a helper in c2, copied down: However I see that I get the same result you wish to get, so I assume this is an option: This will create a new table/query object in Excel with the desired. In other words - it is just a matter of copying the header from a column to the leftmost column of your data, and copying its values down.Īssuming your data is not astronomically large - it is doable in a few minutes. How do you melt columns in Excel Select the columns you want to melt/reshape (ctrl or shift-select, don't drag) In the 'Transform' tab click on 'Unpivot Columns' (you can also apply other transformations here before returning to Excel) In the 'Home' tab click 'Close & Load'. values according to your transposed table's header positions. Transposing does work in your case, all you need to do after is to fill down an extra column which has all ABC/DEF/etc. I know this is not what you're asking, however:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |