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.

More Content

Tech Tip: How to create a transcript using Word

Welcome to another Blisstech Solutions Tuesday Tech Tip! Are you tired of rewinding and pausing video or audio content just to jot down notes? Say goodbye to that tedious process and hello to a more efficient solution. In this tech tip video, we'll show you how to...

Tech Tip: How to manage staff shifts using Teams

Welcome to a new Tuesday tech tip video where we will show you how you can manage your staff shifts from right within Microsoft Teams. The Microsoft Teams app has grown to become one of the most widely used productivity apps in the world, yet most people aren't even...
Slow PCs? Manage which applications launch at startup

Slow PCs? Manage which applications launch at startup

Your PC might be frustratingly slow because too many applications are starting up when you hit the power button. Windows 11 has a new solution to tell you when new apps are added to your startup list. We have all the details.

Tech Tip: Avoid this OneDrive AutoSave Pitfall

Welcome to a new Tuesday tech tip video. In it, I explain a OneDrive AutoSave pitfall that you should learn to avoid. If you use Microsoft Office applications and store your data in OneDrive, you are probably familiar with the AutoSave feature. This does precisely...
How to use Format Painter thumbnail

Tech Tip: How to use Format Painter in Office 365

Welcome to a new Tuesday tech tip video where we will show you how to use a feature of Office applications called Format Painter. If you want to know how to quickly make the content of your Office documents look consistent, then this video will show you how. Format...
This new search feature in Edge is a revolution

This new search feature in Edge is a revolution

Microsoft’s Edge browser has an amazing new search feature that we think is a total game changer, and the most compelling reason yet to switch. We have all the details.

Are your productivity tools actually slowing you down?

If productivity tools aren’t embedded properly within your business, tasks can actually end up taking longer than they should.

Now AI can make your Teams meetings more productive

Microsoft Teams Meeting Recap will summarise your meetings and even make a list of the action points. We show you its other benefits

How to Export or Print to PDF - Thumbnail

Tech Tip: How to save or print to PDF

Welcome to a new Tuesday tech tip video where I will show you how to save files or print documents to a PDF file. In today's digital world, it's more important than ever to be able to print or export files to PDF. PDF stands for Portable Document Format, a universal...
And the award for most common phishing scam goes to…

And the award for most common phishing scam goes to…

Which phishing scam are you and your employees most at risk from? We tell you about the most common phishing emails and the easy way to stay safe.

Share This
Contact
Love Lane
Cleobury Mortimer
Shropshire DY14 8PE

01299 382 321
[email protected]
Copyright © 2024 Blisstech Solution Ltd
Registered No: 08125391 VAT No : 307 5490 05