Choosing specific supplier from mulitple column

[SH_94]

Dear community,

I would like to ask how do we extract the data from the following table . Basically , i want to filter Samsung , bought date and closing date from any column and present in the desired result below:

I have also attached the working as per below.

Thank you.

[Luke_C]

Hi @SH_94 

Try this:

• Transpose the data
• Clean-up the field names (remove the numbers)
• Create a secondary ID to group on
• Crosstab back out
• Filter to samsung

[ChrisTX]

Try the attached workflow.

Chris