Make Alteryx take each column until an empty cell and add across horizonally

Question

Hi, I'm trying to make an alteryx such that I have multiple columns in one excel and I want alteryx to take each column so that it takes it until it reaches a blank cell and then takes the next column.

Then, I wanted it to sum across the rows horizontally.

I'm new to alteryx so I was wondering how this works. I think it is easy to add across rows but the hard part was making sure I am able to group column as it reaches the next emplty cell.

I've attached an example of what my input from excel would be and what my output needs to. If someone could just point me in right direction and tell me which toools to use it would be great.

I'm not sure if there is a way where I can ask altyerx to take an intersection between a row and a column, for example, take the intersection of Feb 10 and Apple and add across.

Thank you

Input.png

Output.png

Qiu · Answer

@PaladinKnight

Can you please provide the input file in Excel format?

Medha31 · Answer

HI,

Please find below the solution. I used a multi-row formula to check if the previous row is null or not, if it is null then incremented table number. Then remove null rows with the help of filter.

Not sure if you want them as separate table outputs, but if that is the case then you can further filter on Table = 1, Table =2, etc.

Hope this helps. :)

Possible Solution.yxmd