top of page

Create and Learn Books - a quick and easy way to learn by doing

Writer's pictureCreate and Learn

Excel Tips - Paste Special to Transpose



You've got a bunch of rows, and you want them to be columns.

Or vice versa...

1- Copy that data, select Paste Special, check the Transpose box, and click OK to paste into a different orientation.

2- Columns become rows, rows become columns!

Comments


The 100 Page Book - Python

Uncomplicated and easy to assimilate structure

Python The 100 page book - cover.png

Power BI – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Power BI 2019.jpg

Excel – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Excel BI ebook 2019.jpg

Power BI, Excel and Tableau – BI Clinic

Learn how to create Dashboard using Power BI, Excel and Tableau.

BI Clinic Complete Single cover.jpg

Power BI Academy: HR Recruitment

Create a complete dashboard for Human Resources. Bonus: 10 Templates

ebook.png

Tableau – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Tableau ebook 2019.jpg

Thanks for submitting!

​

Subscribe to get tips and free material

bottom of page