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

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.

Is your email signature putting your business at risk?

When was the last time you gave any thought to your email signature? It’s just there to provide your contact details and maybe boost your branding, right? But have you ever considered exactly how much information you’re giving away? It’s enough to allow someone else...

Why all businesses should adopt MFA now

Years ago, Multi-Factor Authentication (MFA) used to be called 2FA, or Two Factor Authentication. This was made up of: Something you have, like a device that can generate a one-time password (OTP). Something you know, like a password. MFA has extended things meaning...

How a strategic IT advisor pays for themselves

Does your IT support service help your business grow? Or is it just fixing things when they break? If your current approach is all panic, invoices, and short-term fixes, it’s time for a rethink. A strategic IT advisor becomes a true partner in business growth, helping...

Tech Tip: How to add an email alias as FROM address in Outlook

You've been using Microsoft Outlook for a while now and you're comfortable with the interface. But there's one thing you still haven't figured out how to do- send an email from an alias address. Microsoft 365 has made it possible to easily add a new FROM address in...

Microsoft’s fixing this annoying Windows 11 fault

Fed up seeing useless “Recommendations” in the Windows 11 Start menu? Good news – Microsoft’s making them more helpful. Here’s how the improvements could help your team save time…

Don’t Overlook Home Worker Security

Protecting Home Workers and Your Business In the current work-from-home landscape, business security strategies often overlook one crucial aspect: home office security. This oversight creates vulnerabilities that cybercriminals are actively exploiting. With more...