Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

pivot table , condition Function between cloumn and raw to get new text

Copper Contributor

Matching point between header's column and header's raws at pivot table generate by number, and results to be showed at new table.

Example: if headers cloumn contains A,B,C AND D and Raw contains ONE,TWO,THREE AND FOUR.

Results : in spread table generat a new text accourding to condition of that point matching .

1 Reply
Can you elaborate or show a screenshot of what exactly you want ?