field with multiple names

[#1]

Below PIC one is what I have.

Each FacID has multiple rows

I actually use SQL to get my data.

Can I have a field multiple times and limit the field by the data in the field?

Like Fieldname = capacity as Capacity

        Fieldname = ERX Facility  as ERX Facility

FacID	Field Value	Field Name
home 3	155	Capacity
home 3	12-15-15 PCC	ERX Facility
home 3	07-25-16	V2016 (MM-DD-YY)
home 3		V2016 Clarification Needed
Home1	164	Capacity
Home1	10-06-15 PCC	ERX Facility
Home1	08-31-16	V2016 (MM-DD-YY)
Home1		V2016 Clarification Needed
Home2	140	Capacity
Home2	12-01-15 PCC	ERX Facility
Home2	07-14-16	V2016 (MM-DD-YY)
Home2		V2016 Clarification Needed
home4	117	Capacity
home4	11-15-16 PCC	ERX Facility
home4	08-31-16	V2016 (MM-DD-YY)
home4		V2016 Clarification Needed
Home5	197	Capacity
Home5	PCC	ERX Facility
Home5		V2016 (MM-DD-YY)
Home5		V2016 Clarification Needed
Need to display like this below.
FacID	Capacity	ERX Facility	V2016 (MM-DD-YY)	V2016 Clarification Needed
home 3	155	12-15-15 PCC	07-25-16
Home1	164	10-06-15 PCC	08-31-16
Home2	140	12-01-15 PCC	07-14-16
home4	117	11-15-16 PCC	08-31-16
Home5	197	PCC

[sunny_talwar]

Awesome, I am glad it finally worked. I would encourage you to mark any helpful responses which will help the future audience look for important responses in this thread.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny