Getting comprehensive power over your files at any time is vital to relieve your everyday duties and increase your efficiency. Achieve any objective with DocHub features for papers management and practical PDF editing. Access, modify and save and incorporate your workflows along with other protected cloud storage.
DocHub gives you lossless editing, the opportunity to work with any formatting, and securely eSign documents without searching for a third-party eSignature software. Get the most of the document managing solutions in one place. Try out all DocHub functions today with the free of charge account.
Today lets take a look at transposing our horizontal data to vertical. This time, theres a twist. Actually therere two twists. We dont want to transpose or unpivot every column, just some columns and some of the cells are empty but we still want to see them in our transposed version. Now I have a few videos on this, using the transpose formula, copying and pasting as transposed and also R1 C1 trick. If you missed those, make sure you check them out. Link is below. Today though, were going to do something different and super easy. Were going to use, Get Transform from the data tab. Get Transform is available since Excel 2016. In the older versions of Excel, its available as a free add in, called Power Query. Since 2016, these features became native to Excel. So lets use them to transform our data. (upbeat music) Heres our sample data. We have information on App, the account type, and the value by month. This is the information we want to transpose. And then we want to comb