How to combine some rows of single column as a single cell..

[dizy_11]

Hi all,

I'm stuck at a point with these data. I don't know if we can do this in Alteryx or not.

So I have a table like this.

Furniture	Length	Width	Cost
Table	1m	0.5m	500
Table	3m	1m	1500
Blackboard	4m	1.5m	1000
Blackboard	5m	2m	1500

Now i want data in furniture column to get merged as a single cell for their common rows like this:

Can anyone please tell me solution for this if there is any. 

Thanks in advance!

[john_watkins]

I am not sure about an actual "merge" of the cells since Alteryx treats data in tables as rows/columns.  You may get away with it if building a pivot table from within the reporting group of Alteryx.   The easy way to make it look that way is to create a second column for Furniture2 and a row counter (running total) grouped on Furniture.   Then just make all occurrences of Furniture2 blank when rowid <> 1.  

I don't tend to use Alteryx for output/display or trying to make stuff look like Excel as much because the payoff isn't worth the time in my opinion.  That is where we do that part in Tableau at our shop.  It all depends.

[apathetichell]

This is doable - you'll need three table tools - the first able tool joins fields 2-4 and the second table tool is just for your first column. Then there is some playing around to get them to merge - and a third table tool to get the table borders down.

The hard part is playing with the options on the second table to get them to be the size that you want to match the first table... I'll take a look at it and see what I can do.

[danilang]

Hi @dizy_11 

No, not in Alteryx. All data objects in Alteryx are the equivalent of M x N matrices, where all rows must have M columns and all columns must have N values.  To get what you're looking for, you'll have to output to a display program or create a set of table objects and get them to line up using the reporting tools.  The latter is possible, though finicky, when merging columns, but I've never seen a successful row merge before.  I stand corrected.  Excellent work @atcodedog05  

Dan

[atcodedog05 · Accepted solution]

Hi @dizy_11 

@apathetichell approach was in the right direction. Here is how you can do it.

Workflow:

1. In the first table tool I am using groupby on Furniture(merge cell column) so that they are present outside the table. Note make sure you disable show headings.

2. In the second table tool I am sending the Furniture column and rows associated with it. This creates the merged cell. Note make sure you disable show headings.

3. In the third table tool we will add the header on top of it using union.

Output:

This approach is a bit like playing Tetris you need to align the blocks.

Hope this helps 🙂

[apathetichell]

@atcodedog05great job!

[Ar13f]

Dear @atcodedog05 and members,

Finally, I found this article.... thanks to @atcodedog05 ..

I'd want to request permission to bookmark it.

[atcodedog05]

Hi @Ar13f 

You don't need any permission, go ahead feel free to bookmark it 🙂. We all do it, bookmark helpful posts for reference 😅.