Pivot/transpose - Help Required

RachitKumar
RachitKumar Registered Posts: 2 ✭✭✭

Hi Team,

Can anyone please help me how we can achieve the below:

Input :

PartyAAA
NameA2A
ID100
PartyBBB
NameA2B
ID101
PartyCCC
NameA2C
ID102

Expected O/P -

PartyNameID
AAAA2A S.P.A.100
BBBA2A S.P.F101
CCCA2A S.P.F102

Answers

Setup Info
    Tags
      Help me…