How Do I achieve below output based on data provided?

yogesh_1

I want to transpose the below input format into expected output as below. Please suggest.

Input :

Month	SEGMENT	SITE	Values
Oct-23	Segment1	Site1	1000
Oct-23	Segment2	Site2	984
Oct-23	Segment3	Site3	234
Nov-23	Segment1	Site1	1100
Nov-23	Segment2	Site2	228
Nov-23	Segment3	Site3	2200

Output

		Oct-23	Nov-23
SEGMENT	Segment1	1000	1100
SEGMENT	Segment2	984	228
SEGMENT	Segment3	234	2200
SITE	Site1	1000	1100
SITE	Site2	984	228
SITE	Site3	234	2200

MarkSnodgrass

I would set two constants Segment and Site. Then use the Pivot tile to pivot the segment and sites. I would suggest reviewing the Pivot tile KB article if you are unfamiliar with it.
https://domo-support.domo.com/s/article/360044951294?language=en_US

MarkSnodgrass

I would set two constants Segment and Site. Then use the Pivot tile to pivot the segment and sites. I would suggest reviewing the Pivot tile KB article if you are unfamiliar with it.
https://domo-support.domo.com/s/article/360044951294?language=en_US