Закрыт

Cleanse excel data to be useable in a data base format

I have c120 excel financial data books for airlines around the globe. Each template is set up the same and I am looking to move them into a more database friendly (rows and columns) format so that it can be easily ingested by PowerBI. It wold be a one off project that would cleanse all the existing data and would allow users to update the data manually in the same cleansed format going forward. I have attached 1 example of the financial data book. All are the same although there may be one or two that are very slightly different. The excel includes several rows and complete tabs that are calculation based. The data in these cells is not needed as the calculations will be cover by DAX formula. Only the input data, like yellow cells is what is required.

Навыки: Excel, Visual Basic, Ввод данных, Обработка данных, Power BI

Показать больше: sample supplier data base format excel format, excel vba format data series, excel macro paste clipboard data format, excel code vbs vba data base, write macro format data excel, excel product price list data base, excel google base data, excel macro cell format data, format data output excel, upload data feed excel amazon base, card format data excel, format data entry excel spreadsheet, excel format data cleaning, excel format data, format data series pane excel

О работодателе:
( 0 отзыв(-а, -ов) ) Dublin, Ireland

ID проекта: #32229453

19 фрилансеров(-а) готовы выполнить эту работу в среднем за €937

P0L

(491 отзывов(-а))
8.0
(130 отзывов(-а))
7.3
(322 отзывов(-а))
7.4
(38 отзывов(-а))
7.0
(68 отзывов(-а))
6.9
(227 отзывов(-а))
7.0
(28 отзывов(-а))
6.4
(166 отзывов(-а))
6.3
(29 отзывов(-а))
5.9
(133 отзывов(-а))
6.1
(26 отзывов(-а))
5.0
(24 отзывов(-а))
5.1
(34 отзывов(-а))
4.7
(11 отзывов(-а))
4.4
(16 отзывов(-а))
3.9
(4 отзывов(-а))
3.5
(3 отзывов(-а))
3.3
(1 отзыв)
1.6
(0 отзывов(-а))
0.0