Forum Discussion

egspen2's avatar
egspen2
New Member
3 years ago

Combine multiple tabs with different order of columns

I have multiple tabs of Quickbooks data (each tab is a different year) that is formatted similarly but not exactly the same. My end goal(s) are as follows:

 

1) Breakout account number and account name into individual columns

2) Combine all tabs into one

3) In the combined tab, where multiple years have instances of the same account, I just want one line with this account, with the $ amounts listed chronologically on the same line from left to right. For example, if both 2018 and 2019 have instances of account 12345, I'd like the combined tab to have (from left to right) one line with account 12345, followed by the 2018 value, and the 2019 value respectively.

4) The end / combined tab should have a line for each unique account, whether it only shows up in one period / tab of the original source files or repeats across all of them.

 

I'm a new Power Query user and the issue I'm running into is that the account information is in different columns across each tab.

 

Year 1 Example (account # is in column E):

Year 2 example (account # is in column F):

 

 

1 Reply

  • Are you able to post sample data? Sanitized, of course.