sergiopcrt
New Member
- Joined
- May 12, 2017
- Messages
- 12
Hi Everyone,
I don't know if this is possible but I have 100+ columns like this
Cat1 | Cat2
place1 Place3
place2 Place5
place3 Place6
Place7
the columns have variable length and I need to transform them in
Cat1 | place1
Cat1 | place2
Cat1 | place3
And do this in either different sheet or workbook, one table for each Cat.
Do you know if this is possible? Any help would be appreciated.
Regards,
Sérgio
I don't know if this is possible but I have 100+ columns like this
Cat1 | Cat2
place1 Place3
place2 Place5
place3 Place6
Place7
the columns have variable length and I need to transform them in
Cat1 | place1
Cat1 | place2
Cat1 | place3
And do this in either different sheet or workbook, one table for each Cat.
Do you know if this is possible? Any help would be appreciated.
Regards,
Sérgio