VIDEO: How to Tidy up Copied Data in Excel
Author : Finlay Britnell
15 March 2022

This Tuesday Two Minute Tech-tip shows you how to tidy up data in Excel spreadsheets.

Do you have data in a messy format and need to change it so it is organised?

Have you ever received data in Excel or in a text file or Word document and wanted to change it from rows to columns, or vice versa?

Maybe you have done this manually in the past, which can take a lot of time!

This tip will save you a lot of time by explaining:

👉 How to tidy up a messy spreadsheet into something neat and organised.
👉 How to move data from rows into columns.
👉 How to split data from one cell into separate columns.

These tips will help you to:

💥 Save time by avoiding manual data entry.
💥 Quickly manipulate data in Excel using some neat tricks.

Check out the video to learn more and subscribe to our YouTube channel https://www.youtube.com/channel/UCr8R-LSAjMvvuF65EtwSRag

Thanks for watching.

More Content

Why setting up Facebook Wi-Fi for your business is a good idea

Setting up Facebook Wi-Fi for your business is a great way to increase customer engagement and loyalty. When customers connect to your guest Wi-Fi they can check in to your business on Facebook to gain access rather than entering a WiFi code. This allows them to stay...

Is Your Business Ready for Another COVID-19 Lockdown?

Given the rapid rise in cases over the past few weeks, another lockdown was inevitable. Employers and employees alike will now be used to a 'new normal' where we are encouraged to work from home. During the last lockdown, we all learned that it is possible for us to...

VIDEO: An overview of Microsoft Teams

Welcome to a new Tuesday Two Minute Tech Tip that covers the basics of Microsoft Teams. Microsoft Teams has become one of the 'go to' tools for collaboration since the start of the pandemic, but most people are only scratching the surface of what you can do with it....

Office 365 and Windows RDS: Maximum Remote Working Flexibility

Windows Remote Desktop Services (RDS) has been around for years. I was using it over 20 years ago and was a fan.  It was an excellent solution for flexible working over slow connections, which is all we had back then!  However, back then, you needed something else to...

VIDEO: How to use Pivot Tables in Excel

Welcome to Tuesday's Two Minute Tech Tip where Matt shows you how you can explore your Excel data using the power of Pivot Tables. Pivot Tables are a powerful feature of Excel that allows you to manipulate your flat Excel data to perform calculations and create charts...

Spam emails are losing your business hundreds of hours every year

Spam emails: Very annoying and everyone hates them! They take up your time and make it hard for you to get other work done! A recent study found that each one of our employees could be losing 80 hours per year due the hassle associated with managing spam. That’s a LOT...

Get on top of this now if any of your staff are hybrid working

People are increasingly doing their work remotely and hybrid working has become the new norm. Despite the fact that it has been more than two years since many of us were forced to work from home, too many organisations still do not have the appropriate cyber security...

VIDEO: How to use a Password Manager

This Tech Tip is a tip on how to manage your passwords. It's a long tip this week, but that's because there is a lot to tell! With so many things being done online now, passwords are needed constantly.  But with the advice that every password should be unique and not...

VIDEO: How to get the most out of Google searches

Hello everyone! Today's Tuesday Two Minute Tech-tip shows you how to get the best out of your Google searches. Google search is arguably the best in the world and gives us the internet at our fingertips, but it can be hard to find what you are looking for. This tip...

VIDEO: How to use Templates and Slide Masters in PowerPoint

This Tech Tip will show you how to use templates and Slide Masters in PowerPoint to give your presentations a professional and consistent look. I've been using PowerPoint for over 25 years and have created a lot of presentations. Previously, I would work from a...
Share This