Reformatting Data

Data can become overwhelming very quickly.

Maybe it looks like a tree farm to you. Everything is the same, and you don't actually see anything specific.

These tips and tricks will help you to see specifics among the data.

Reformatting Data to Make It Usable

Splitting Text to columns

splitting text from one column to many columns
inserting a cell to move data over one cell

Transposing data

transposing vertical data to be horizontal in one click

Removing partial Data from within a column

using find...replace to remove unwanted data
splitting text to columns
app smashing with Google Docs to apply title case to first and last names

merging data from two columns into one

using the ampersand (&) character to merge cells
Inserting a space or other characters using quotation marks

Google Sites

Report abuse