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? →

How to plan a big IT project

We all dream of making changes to our business that will make us more efficient and profitable, but significant changes to the technology you use to run your business should never be rushed.

Get ready for another game-changer from Teams

Microsoft is working hard to lead the AI revolution and its latest update to Teams will certainly make it a front-runner. We think the potential is unlimited, here we’ll tell you why.

Are your people Christmas shopping from work?

Almost half of people with social media accounts admit to falling for shopping scams. If your team are shopping at work, is your business protected?

Broadly speaking there are two different types of desktop computer users; Windows users and Mac users (sorry Linux users but you are very much in the minority). Microsoft has included a free antivirus solution called Windows Defender for years because they realised...

Managed IT Services consultant connects a network cable into switch

What are the benefits of outsourcing IT support?

Have you ever started a DIY task only to wish you had just called in an expert? Your IT support should be no different. Many business owners think that they can handle their IT systems themselves. However, unless they have the experience and finger on the pulse of...

Tech Tip: How to share files securely in Teams

Welcome to a new Tuesday tech tip video where we will be exploring how to share files securely with people outside of your organisation using Microsoft 365 and Teams. Microsoft Teams is a powerful tool that allows for seamless collaboration and communication within an...

Are you really downloading Zoom – or is it malware?

When you think about tools for remote working and chatting online, one of the first names in your mind is Zoom. But its popularity has opened the door for cyber criminals. They’re using its name to steal sensitive data. Researchers have discovered at least six convincing-looking download sites. They’re not the real thing. They’re designed […]

How to Plan for Upgrading to Windows 11: A Guide

The Clock’s Ticking for Windows 10: Are You Ready? 14th October 2025 is the day Microsoft ends free support for Windows 10. This means no new features, no bug fixes, and no more security updates. You can't risk that. Why Upgrade to Windows 11? Windows 11 offers a...

Tech Tip: 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...

If it ain’t broke… Windows update makes signing out simple again

Windows update makes is easy to sign out of Windows 11 again

Having trouble finding the sign out button in Windows 11? You’re not the only one! Luckily, Microsoft have listened… find out more here.

More Content