Forum Discussion
retain formatting thru unpivot process
90 percent of all data I analyze is a combination of dollar-formatted data ALONG WITH percentage data. After cleaning data and properly categorizing it as either currency or percentage, how do I kee...
you can't have mixed formatting in a column so maybe unpivot twice - first on the numerical data and second on the percentage data
can you unpivot them separately from the same sheet, or do you need to copy/paste the percentage columns along with primary shared column to another excel sheet and do it there, effectively creating 2 tables?