Transpose of Data

[Jeyaraj_M]

Hi Team,

Need your expertise support.

I have the below information extracted from the source data say (Table1)

F1	F2
File No:	24685
Date	12/15/2020

In the other table i have the data as below say (Table 2)

Header1	Header2	Header3
a	b	c
d	e	f
g	g	i

Now i need the data table Table 2 to be add the table 1 information repeat all item labels as below

Header1	Header2	Header3	F1	F2
a	b	c	24685	12/15/2020
d	e	f	24685	12/15/2020
g	g	i	24685	12/152020

[marcusblackhill · Accepted solution]

Hey @Jeyaraj_M !

Actually, you need to crosstab you data and append them, look the example attached.

Hope that helps!

[Jeyaraj_M]

Thanks Marcus really appreciated