Showing posts with label analytics. Show all posts
Showing posts with label analytics. Show all posts

Thursday, February 15, 2018

Excel Hacks : How to copy data in row of excel into a column (Transpose)

Working on a data science project makes you play with diverse data sources in the most crazy way you can imagine.

While aligning the data programmatically via data frames in the most sane way to do, but sometime you just want to check the data in a quick dirty way via the all familiar Excel.

Aligning the data in one format (vertically or horizontally) can be a challenge though, since there is no universal rule for defining what should be on X axis and what should be on Y. There is one trick though you can use to quickly transpose the numbers either way (vertical to horizontal or vice versa)

1. Copy the data, say which is present in the horizontal format.



2. Go the sheet now where you want to paste this in the vertical format, right click on cell where you want data to start from, right click, and from Paste options choose Transpose option.

Paste Options menu

3. You will have the data in the format you want.






Merging and Splitting PDF files

We all use and rely on PDF's. There are occasions though when you want to edit certain portions of a pdf and merge the edited version ba...