Different outputs in a Same Tab
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I am having this two ouput, trying to combine them in a same sheet with spaces between them.
I have attached workflows and a expected output. Please kindly assist me on this.
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sarath27 One way of doing this with the reporting tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sarath27 Another option
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Thanks much for your solution. It worked well. Could you also please assist me on this well? What if I have more than 4 outputs? Do I need to use two appends and join? Can you please explain just by duplicating those 2 outputs to 4 outputs?
Thanks in Advance,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sarath27 Do you mean 4 input files to one Excel sheet in different sets of columns?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Exactly. I have 4 different ouputs each has 100+ rows with 15 columns, I want all of them to be in same tab just like we do in excel piivot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @binuacs
This solution really worked well.
But please help me with this as well.
The output from this macro should be taken out and the same has to be populated as a sheet in a final output. I don't see an output anchor in that macro. Please kindly help me with that.
I have also attached the snap of that particular part in the workflow, pls help me withat
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Could you please help me with this ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sarath27 Add a macro output tool inside the macro to get the records from the input file
