Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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):
Are you able to post sample data? Sanitized, of course.