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

Before you replace your slow PCs…

Windows PCs running slowly? It doesn’t necessarily mean it’s time to replace them. There are some other ways you can give things a boost. We’ll tell you how.

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.

Ransomware Attacks Grow for Small Businesses

Two organisations have recently released reports on the state of ransomware and cybersecurity incidents affecting small businesses. Datto's State of the Channel Ransomware Report Datto has recently released their "State of the Channel Ransomware Report" for 2019...

10 Simple Tips for Avoiding Phishing Scams: How to Stay Safe Online

10 Simple Tips for Avoiding Phishing Scams: How to Stay Safe Online What is Phishing? Phishing is a common online scam in which cybercriminals try to trick you into sharing personal information, such as passwords and credit card numbers. Phishers often use email or...

Templates and Slide Masters in PowerPoint title

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

Make sure your cloud server is protected from this

Using a cloud server to drive your business’s technology is a smart idea. The benefits are huge. You can use as little or as much storage as you need, without having to worry about limitations or huge bills. Perfect for growing businesses. Your team can access any...

Is your business data at risk? Don’t take chances with old tech

Old computers and external drives can put your sensitive business data at risk.
We look at how to dispose of old computers and external drives in the safest way possible.

Tech Tip: How to create a scheduling poll using Outlook

Welcome to a new Tuesday tech tip video where we will be exploring how to create a scheduling poll using Outlook. You know what it's like when you are trying to get everyone together for a meeting. Trying to find a time that suits everyone can be a real pain! There...

Is Your Business Ready for Coronavirus Lockdown?

With the COVID-19 coronavirus continuing to spread in the UK, and Italy and China placing lockdowns on their towns and cities, it seems likely that the UK will follow suit if the outbreak continues apace. Experts have stated today that the spread of the virus in the...

Tech Tip: Send quick Teams messages from anywhere

We all know that Teams messaging is a great way to communicate with others, but it can be disruptive if it interrupts our flow. Even though Teams messaging is a great way to communicate with colleagues, it can easily break your concentration and flow. You might find...

More Content