Tech Tip: How to Tidy up Copied Data in Excel

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.

← The tax relief few businesses know about What are the benefits of outsourcing IT support? →

Tech Tip: How to check if your device is compatible with Windows 11

Welcome to a new Tuesday tech tip video. In it, I will show you how to check if your device is compatible with Windows 11. With Microsoft's termination of support for Windows 10 in October 2025, it's crucial for business leaders to proactively plan for the transition...

How to Secure Your Business from Cyber Threats in 2024: A Free Guide

Protect your business from these cybersecurity threats in 2024 We’re weeks away from the new year. And this is a great time to start thinking about what needs to get better in 2024. We believe you should allocate more of your business’s precious resources to the...

Reverse image search makes purchasing and marketing easier

Bing Visual Search makes purchasing and marketing easier

Think the Windows 11 Photo app has little use in your business? Visual Search with Bing is about to change that, with some very useful new functionality… Find out more here.

Businesses are taking too long to fix vulnerabilities

If you knew your systems were at risk of attack, you’d jump in and get things locked down fast – right? Actually… many businesses take too long to fix vulnerabilities. Here’s why that’s a problem.

Tech Tip: How to search for files in Window and Microsoft 365

Welcome to a new Tuesday tech tip video where we will show you how to find your files using the powerful search features of Windows and Microsoft 365. Even if you are very organised with filing your data, sometimes, you just cannot find the file that you are looking...

How to get faster Wi-Fi in your office and for remote workers

The quickest way to upset your staff is by giving them slow access to the internet. Bad Wi-Fi quickly creates tension in the team and is a real productivity killer. You don’t have to suffer slow Wi-Fi. Here’s our guide to making Wi-Fi faster whether you’re working in...

Tech Tip: Capture Your Screen Like a Pro – Essential Screenshot Techniques for Windows

Welcome to a new Tuesday tech tip video where I will show you how to take screenshots in Windows. Screenshots are an indispensable tool for anyone who uses a computer. They allow us to capture specific areas of our screen, share instructions, document errors, or...