Plan to work on the database…Niat untuk melihat database Yezza.

When downloaded, this happened!

Don’t panic.

The data can still be rearrange by using text to column steps

Steps are :

1. Click column A
2. Click <Data>
3. Click <Text to Column>
4. Click <delimited>
5. Click <Next>

94640926_133377561639359_6785148579276128256_n.png

6. Choose one of <delimiters>.

If you study the first picture, details like invoice_no date and form name are seperated by comma (,). So choose comma.

csv_3.png

7. Click <Next>
8. Then click <Finish> when finished

If you use Microsoft Excel with at least 2013 version, usually the program will automatically sort the data.

Click Link below for full list Yezza guide

Yezza Guide – Road To Expert