Can anyone help me in combining two columns data into one column and one column data into one row?

[Pooja_Mishra]

Hi All,

I have a raw data and I need to combine two columns (Status Mapper and Ultimate Group Mapper) into one column and one column data  (Value Mapper) into one row , as shown in New Table. Can anyone please suggest how to do this.

Raw Data
Status Mapper	Ultimate Group Mapper	Value Mapper	Item Counter
PL	DW	+$250m	1
PL	DW	+$250m	1
PL	SPG	+$30m	1
PL	DW	+$10m	1
TD	DW	Missing numeric value	1
PL	SPG	+$30m	1
PL	SPG	+$250m	1
TD	DW	-$10m	1
#N/A	#N/A	+$250m	1

New Table
	-$10m	+$10m	+$30m	+$250m	Missing numeric value
PL		1	2	3
TD	1				1
DW	1	1		2	1
SPG			2	1

[Anonymous · Accepted solution]

you can get what you ask by making two pivots and an append table.

[AllisonKennedy · Accepted solution]

I would suggest using a Matrix visual and keeping the raw data as is.
In Matrix visual:
Item Counter in Values (as SUM)
Value Mapper in Columns
Status in Rows

[Anonymous · Accepted solution]

you can get what you ask by making two pivots and an append table.