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

HRMC Crown

The tax relief few businesses know about

A quick summary: When you buy certain new equipment (including computers) you can claim 130% capital allowance What that means: If you spend ÂŁ1,000 on computer equipment, it'll reduce your corporation tax bill as if you had spent ÂŁ1,300 How long does it last? It will...

Why setting up Facebook Wi-Fi for your business is a good idea

Setting up Facebook Wi-Fi for your business is a great way to increase customer engagement and loyalty. When customers connect to your guest Wi-Fi they can check in to your business on Facebook to gain access rather than entering a WiFi code. This allows them to stay...

IT Security Still Top Concern For SMBs

A new report from Kaseya reveals that IT Security is still the top concern for small and medium-sized businesses.  The “2019 State of IT Operations for Small and Midsize Businesses” survey took input from more than 400 global respondents and reveals that 32% of...
Scam hazard signs

How to spot a scam

Would you know how to recognise a scam? In the 21st century, you are highly unlikely to encounter a con artist in the street as they hide behind phones, text messages and emails.  But the motivations behind 21st-century fraudsters have not changed; they want to make...
A handshake reaching out of a laptop screen

What is a managed service?

If computers are an essential part of your business you will probably have someone looking after them for you, but what type of service are you getting from them?  Have you heard the expression "Managed Service" or "Break/Fix"? You may have heard these expressions and...
Cyber security training once a year isn’t working

Cyber security training once a year isn’t working

You’re wasting your time on annual cyber security training. Why? Because it’s simply not cutting it anymore. Discover a better plan here.

How to use Browser Profiles thumbnail

Tech Tip: How to use browser profiles

This Tech Tip is on how to use web browser profiles. If you are a freelancer, virtual assistant, or just wear many hats in your job role, you probably have multiple different logins for the same application. As so many applications are web-based, we have to login to...
PING, WHOOSH, or BEEP? Now you can decide with Teams

PING, WHOOSH, or BEEP? Now you can decide with Teams

Is the sound of yet another Teams notification about to drive you crazy? A new update will put a stop to that… and it’ll help you prioritize your tasks too. We have all the details here.

Power Automate and Flows Thumbnail

Tech Tip: What is Microsoft Power Automate?

Welcome to a new Tuesday tech tip video where I will give you a quick introduction to Microsoft Power Automate. We all want to streamline our work life and make ourselves more productive. Well, if you use Microsoft 365, you can do just that by using Power Automate....
How to use crossreferences in Word

Tech Tip: How to use cross references in Word

Today's Two Minute Tech Tip is another tip for Microsoft Word. If you use Word to write documentation, contracts or any other type of detailed document, then this tip is for you. Usually, when you write such a document, you need to refer to other places in the...
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