Data Split into Tables and Append Tables

Question

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?

anonymous · Accepted Answer

Hi&nbsp;arafmustavi&nbsp;,
&nbsp;
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.

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
&nbsp;

Forum Discussion

Data Split into Tables and Append Tables

2 Replies

Related content

Append table kpi's

Table append issue

Matrix table

Appending and Merging tables

Lakehouse Table Generate Create Table