Appending Charts using Power Query Excel 2016

Hi every body,

I am hung up on chart formatting and need your help please.

I have several tables (same format ) from different projects that I should update monthly to further analyze.

At the same time, I have to do dashboard to compare all the projects and do an overall analysis on all.

I want to create a main table that should automatically bring the data from other tables when I update them.

I use power query to append the tables together, but by saving the table, I'm getting an erorr.

or if there is any other ways to bring all data from Tables to main Table.

My table Header is as follows:

Date. Project name, , Creditors, . const type Nr. Amount, quantity, description,

2.2.2018 , Same names , different , different .., .... , ...., ... .......



but in Main table the Projekt column ist with several names.



Thanks for your ideas in advance

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi sandy
Thanks for your reply.

i have attached the simple file..
i need to get Main table updated, whenever i update other tables.

with PowerQuery (Get&Transform) and PivotTable.
is that what you want?

yes thats what i need.
Thanks
but how you made it?

I am using Excel 2016 German version and i dont know how to create such a list.
I have treid using APPEND command, but i get errors.

General Note: Read me Try to avoid joining to my Black List by doing this below If that takes care of your original question, & to say Thanks and for better Motivation, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. If you did it already - ignore it. Thank you.

Hi Dear Sandy,

I attach the tables to each other, but I get the files doubled.
but when i am in a Table and Appending the Data to this table, tha date comes correctly in Power table but i get 42 errors, when i click on error it doesnt show me anything in error table.

i have 8 Tables With 110000 rows.


I do it as follow.

-Format Tables.
- add to power query from Table
- Close and Load
- creat links
same Procedure for all table and at the end.

Open Power Query editor..

-Apend tables with each other
-Save and load
-Load in a new table.

but at the end i get either Error or Doubled.

The Tables are same as your table but somtimes with Zero in Cells.

what do you think, whats the Problem?

Thank you so much

here is the File

Please Update it and see if you get error by updating the file..
Thanks

after clean your source tables I don't see any errors in Append table

I still get this error by updating the Table (reference is not valid , atleast one connection didnt updated).
but its no problem i am working with your table.

Thanks alot for your help

Clean all your source tables:

• select each whole sheet
• select Clear Formats
• remove all freezes
• set the same format for all surce table
• one of your table has additional blank row - remove it
• set dates to dates (column A) if you want but you can do that in PQ Editor
• set text format to last column in PQ Editor (mixed text and number)
• and now you can use Append (probably)

General Note: Read me Try to avoid joining to my Black List by doing this below If that takes care of your original question, & to say Thanks and for better Motivation, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. If you did it already - ignore it. Thank you.