web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to combine workshe...
Power Apps
Unanswered

How to combine worksheets in power query

(0) ShareShare
ReportReport
Posted on by

I have a set of data in three different worksheets. Shown below is a sample of data in the first 12 rows of each worksheet

 

I will like to

 

(i) combine the 3 worksheets into a single table and

(ii) add a label to each column (or header to the table). For example, the 8 columns will have headers A,B, C, D, E, F, G, H

 

 

Worksheet 1

119421352516129
424341483188
1533149120114140
83137596711075
16140891432030
32251328948121
93408411412174
5674451042882
255811710085133
87684712714051
95248110285102
11770103571829

 

 

Worksheet 2

5
10
2
27
12
12
12
19
10
3
21
8

 

Wrksheeet 3

 

180
131
192
125
224
200
218
184
199
224
138
174
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard