Forum Discussion
Solved
Power Query to generate 3 columns based on 3 tables
Hello, I have three tables and I want them to be shown in one table with 3 new columns created from them. The 3 tables are named as below with below data: This table name is main and its data is: ...
Hi Junaid11 ,
I made a sample file for you. Please download it for details.
The main idea is to use the Append function to append the category column and the name column.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello AntrikshSharma ,
I wanted to find out if the same category and category name was in each file name then there should be put one its column name like category J-1 and category name ABC was in file Main as well as in LLP file so I put 1 in their columns while it was not in REN table so it has blank infront of it