Hi dear freelancers :-)
I need to get an Excel for a bulk upload for google local. Here is any information about how this sheet should look like [login to view URL]
I got a german Excel sheet with some information. (attached file)
Here´s the tasks
1) In column AW there are the hours (Öffungszeiten) in a weird style. I need a new column (=M) with this style :
Option 1 - In 24 hour format:
2:10:00:18:00,3:10:00:18:00,4:10:00:18:00,5:10:00:18:00,6:10:00:18:00,7:12:00:20:00
Explanation:
The first entry is for Monday (day 2).
The opening hour is 10:00 (10 am).
The closing hour is 18:00 (6 pm).
2) I need another new column (=N) with the categories:
You can see the right categories in columns A-D >>>> X
The new column should contain the right categories like this: Just put the name of the supported category into the spreadsheet. You can add more than one category to your spreadsheet by using commas as separators.
You can see the right category in the sheet by a X
the result should look like this:
first line:>> column N : Elektrofachgeschäft, Telekommunikation
Thank you very much :-)