Forum Discussion

rfway's avatar
rfway
Icon for Helper I rankHelper I
10 years ago

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...
Need Help
austinsense's avatar
austinsense
Icon for Impactful Individual rankImpactful Individual
10 years ago

you can't have mixed formatting in a column so maybe unpivot twice - first on the numerical data and second on the percentage data

rfway's avatar
rfway
Icon for Helper I rankHelper I
10 years ago

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?