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

When can you finally forget your password?

Passkeys are set to take over from traditional passwords to give us a safer, more secure way of logging into our online accounts.

Why a business password manager is essential

Still using spreadsheets or sticky notes for your business passwords? It might seem harmless… but it’s one of the biggest risks to your security. Weak or reused passwords are how most hacks happen. And if one login gets leaked, cybercriminals can gain access to...

Unwrap the gift of knowledge: 5 free AI courses by Microsoft

Unwrap the gift of knowledge: 5 free AI training courses by Microsoft

Microsoft has a little business-boosting gift that you won’t want to miss out on… five free courses about AI. We have the details, and the links to the courses.

This tiny tweak to Teams will make meetings smoother

Sick of saying “next slide please” in your Teams meetings? Microsoft has a small but powerful new feature that will put an end to that. Find out more here…

How to get the most from Microsoft Teams

Is your business struggling with too many emails, lost files, and “final_final_v3” documents? Teams could be a game changer. Yep, it does more than just video calls. For example, you can also: Chat with your employees Host webinars Share and edit files together Keep...

Why the Cloud is not backup

Cloud computing has revolutionised the way businesses work. Companies that utilise the cloud will have coped the best with COVID-19 imposed restrictions. Whether forced to by circumstance or not, businesses are moving from the traditional server in the office to...