Hi all, I am trying to output a table into multiple tabs after removing null columns. Example input: LBL Owner Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 Header 8 Header 9 Header 10 A Zxx 200 400 100 200 400 B 300 300 xsw cww ww C 200 A 100 200 400 ww ww ww www ww B 300 300 ww dd C 200 dd dd The output excel would have the three tabs with following different tables: Tab A LBL Owner Header 1 Header 2 Header 4 Header 5 Header 6 Header 7 Header 8 Header 9 Header 10 A zxx 200 400 100 200 400 A 100 200 400 ww ww ww www ww Tab B LBL Owner Header 1 Header 3 Header 5 Header 6 Header 7 Header 8 Header 10 B 300 300 xsw cww ww B 300 300 ww dd Tab C LBL Owner Header 4 Header 7 Header 9 C 200 C 200 dd dd I am currently using a saving each LBL Owner in an output tool that takes file name from the "LBL Onwer" column (multiple tabs same file) Problem: The output file does have different tabs, with just relevant rows, but it outputs all the columns, including the empty ones. I have searched everywhere to try and resolve this issue, I really hope you guys will be able to help!

Remove Null Columns and output in multiple excel sheets/tabs during saving

Hi all,

I am trying to output a table into multiple tabs after removing null columns.

Example input:

LBL Owner	Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10
A	Zxx	200		400	100	200		400
B	300		300			xsw		cww		ww
C				200
A	100	200		400	ww		ww	ww	www	ww
B	300		300		ww		dd
C				200			dd		dd

The output excel would have the three tabs with following different tables:

Tab A

LBL Owner	Header 1	Header 2	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10
A	zxx	200	400	100	200		400
A	100	200	400	ww		ww	ww	www	ww

Tab B

LBL Owner	Header 1	Header 3	Header 5	Header 6	Header 7	Header 8	Header 10
B	300	300		xsw		cww	ww
B	300	300	ww		dd

Tab C

LBL Owner	Header 4	Header 7	Header 9
C	200
C	200	dd	dd

I am currently using a saving each LBL Owner in an output tool that takes file name from the "LBL Onwer" column (multiple tabs same file)

Problem:

The output file does have different tabs, with just relevant rows, but it outputs all the columns, including the empty ones. I have searched everywhere to try and resolve this issue, I really hope you guys will be able to help!

Custom Tools

Accepted answers

afv2688

Hello @MI1 ,

Sorry for the misunderstanding. Think I got the right solution now 🙂

Regards

rename sheets.yxzp

pedrodrfaria

@MI1

Here are the files @afv2688 shared.

Right click on them and open as a notepad, there you should be able to change the version to your version and then save it.

rename sheets.yxmd

rename sheets.yxmc

All comments

afv2688

Hello @MI1 ,

On the output tool you are able to select on which column you want the data to be separated:

Regards

rename sheets.yxmd

MI1

Hi @afv2688

thanks for the fast answer

The challenge is not to save in multiple tabs, the solutions offered is already in place , or even with setting up the path name directly.

The main challenge which is to remove all empty columns in each tabs during the saving.

1- The main data is already without empty rows (50K rows) + 600 headers however 24 different tabs (can vary)

2- when I want to saved at a granular level, then I get some empty columns again as the 600 headers may not be in use in each tab.

I get a VBA code to loop each sheets and then delete each empty columns, however it take at least 15 min to run, checking if alteryx could help to format data directly.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280