Tech Tip: How to Tidy up Copied Data in Excel • Blisstech Solutions

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 Much Should You Pay for IT Managed Services in the UK?

This article has been updated to reflect the market in 2026. If you are looking for managed IT services in the UK, you should understand that there is no "one-size-fits-all" solution. There are many managed service providers out there, and they offer a huge range of...

Do you really want your team to use this?

If someone on your team could buy something for work without ever visiting a website (or leaving their desk), would you know?
AI tools are changing how everyday work happens.
And now that even includes decisions that used to have checks and processes…

Ransomware threats are surging – here’s how to protect your business

After years of decline, ransomware attacks are on the rise again. And more businesses are being targeted. It’s time to protect your data. Here we explain how.

Say goodbye to video call pop-ups (and Teams meeting blushes)

Has a pop-up notification ever embarrassed you while you were on a video call? Microsoft may finally have a feature to stop that happening. Learn more here.

Prepare your business for more refined cyberthreats

Cyberthreats don’t look the way they used to.
They’re quieter now. Smarter. Harder to spot until it’s too late.
If you think today’s attackers are still using old school tactics, you might be missing the real danger already moving in the background…

You’ve heard of Copilot… but what is it?

You might have heard about Microsoft Copilot, but what is it? And will it really make a difference to your workday or business? We explain it all here.

A semi-transparent padlock icon sits at the centre of the network

How Cybercriminals Are Using AI to Attack Small Businesses (And What You Can Do About It)

Running a small business is demanding enough without having to worry about whether a hacker is using artificial intelligence to plan their next attack on your company. But that is exactly what is happening. A recent report from Microsoft Threat Intelligence confirms...

Firewall 101: What every business should know

Is your firewall quietly doing its job… or quietly letting threats slip through? Most small business owners never think about it. It just sits there, working away in the background. But if your firewall isn’t set up properly, or if it’s using basic, outdated...

Are your employees reporting security issues fast enough… or even at all?

The faster your employees report a potential cyber security issue, the less damage is done to your business. But how can you encourage quick reporting? Here we share some solid ideas.

Windows 10 is getting a very useful Windows 11 feature

There’s no denying that Windows 11 has a lot of really cool new features. If you haven’t made the move from Windows 10 yet, you’re missing out. But there’s good news. To make the (eventual) move from Windows 10 to 11 a little easier, Microsoft is sharing a couple of...

New! A better way to find Chrome extensions

The Chrome Web Store’s been given a massive makeover, and it’s all about making your team’s life easier. We have all the details.

More Content