LittleStes
New Member
- Joined
- Apr 10, 2022
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
As an example, need to lookup x in a table and pull in all results of TRUE but one at a time and each in a separate row.
Need to get into format similar to below
X TRUE
X TRUE Value #2
X TRUE Value #3
Y TRUE
Y TRUE Value #2
From a reference table in format:
X TRUE TRUE Value #2 TRUE Value #3
Y TRUE TRUE Value #2 FALSE
Any thoughts on a quick way to automate this would be greatly appreciated.
Need to get into format similar to below
X TRUE
X TRUE Value #2
X TRUE Value #3
Y TRUE
Y TRUE Value #2
From a reference table in format:
X TRUE TRUE Value #2 TRUE Value #3
Y TRUE TRUE Value #2 FALSE
Any thoughts on a quick way to automate this would be greatly appreciated.