I’m trying to take the first table in the linked sample sheet below and transform it into the formatting of the second table in that same sheet, which is more of a list view. Here is a sample sheet with this data.
I was thinking I could use a query or filters but can’t figure out how to do so successfully, incorporating all desired information into the output table. I want to only include details in the output table, when the hire need is greater than 0.
Thanks in advance!
1
You can use:
=ARRAYFORMULA(QUERY(
SPLIT(TOCOL(C4:N4&"|"&C5:N5&"|"&B8:B12&"|"&C6:N6&"|"&C7:N7&"|"&C8:N12),"|"),
"where 0<Col6"))