Make value in a column into columns

[Anonymous]

Hello this is what my current data looks like: - I need the company name to be in the column - Please help 

COMPANY Number	COMPANY Name	Account Description	Type A	Sort	Type B	FY18	FY 19	FY20
1	ABC Company	Non-Guaranteed Revenue	GAAP Revenue	1	Display / Video	16	1	2
1	ABC Company	Other Revenue	GAAP Revenue	1	Other Revenue	1	3	4
1	ABC Company	A Expense	EBITDA	5	Cost of Revenue	(9)	3	4
1	ABC Company	B Expenses	EBITDA	5	Cost of Revenue	201	3	4
1	ABC Company	Cost of Goods Sold	EBITDA	5	Cost of Revenue	(5)	3	4

And I would like it be be like this:

Account Description	Type A	Sort	Type B	ABC Company FY18 Amount	ABC Company FY 19 Amount	ABC Company FY20 Amount
Non-Guaranteed Revenue	GAAP Revenue	1	Display / Video	16	1	2
Other Revenue	GAAP Revenue	1	Other Revenue	1	3	4
A Expense	EBITDA	5	Cost of Revenue	(9)	3	4
B Expenses	EBITDA	5	Cost of Revenue	201	3	4
Cost of Goods Sold	EBITDA	5	Cost of Revenue	(5)	3	4

[ERD · Accepted solution]

Hi @Anonymous ,

1. Choose columns with values (FY18 - FY20), click Transform - Unpivot columns (you will get 2 columns: Attribute & Value).

2. Choose Company_name and Attribute columns, click Transform - Merge Columns, choose Space as a Separator (you will now see 2 columns: Merged & Value).

3. Choose Merged and Value columns, click Transform - Pivot Column. Values column - Value, Aggregate Value Function - Don't aggregate (Advanced options).

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Anonymous]

Thank you so much @ERD this save me so much headache. 🤗