Data Split into Tables and Append Tables

[arafmustavi]

Hi,
I have loaded the data from and excel and the excel sheet has three table in a sheet. My dataset looks like this
CATEGORY A  CATEGORY B CATEGORY C
PRODUCT  PRICE  PRODUCT  PRICE   PRODUCT  PRICE
PROD A1 100 PROD A2 150 PROD A3 150
PROD B1 200 PROD B2 250 PROD B3 250
I need my Data in the following format
CATEGORY PRODUCT PRICE
A PROD A1 100
A PROD B1 200
B PROD A2 150
B PROD B2 250
C PROD A3 150
C PROD B3 250
Any idea how I can do this?

[v-stephen-msft · Accepted solution]

Hi @arafmustavi ,

Supposing below is your data.

You can duplicate two tables and set three tabls to the same column names, "PRODUCT", "PRICE", and "CATEOGRY".

The "CATEGORY" is a custom column added manually.

Table:

Table (2):

Table (3):

Append them.

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.           

[ImkeF]

Hi @arafmustavi ,
having problems to understand the structure of your source data, specifically the headers.
Please check out this article on how to provide usable sample data: How to provide sample data in the Power BI Forum - Microsoft Power BI Community