Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
egspen2
New Member

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):

egspen2_0-1683556263914.png

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

egspen2_1-1683556436030.png

 

 

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors