Combining data that is split with a name row within the same sheet

[sowjanyayinti]

Hard to explain so I am attaching sample data. Basically a file that is split with different company names. What is the easiest/fastest way to combine them so the final output looks like the one in the 'Output' tab of the attached sample file?

Thank you in advance.

[KGT]

OK, so normally I would tag lines and then formulas to work out which elements go where in the final table... (not complicated, but a few tools)

But, in this case you just have a filter on !IsEmpty([Date]) and get your table?

[sowjanyayinti]

But how do i get the company name into a column of its own for the rows it is specific to? Cross tab and transpose?

[ntakeda · Accepted solution]

@sowjanyayinti 

following steps:

1. Use the Multi-Row Formula tool to retrieve the company name when "Number" is null. Otherwise, retrieve the company name from the previous row.
2. Filter out rows where "Number" is null.

Please check the workflow for details.

[sowjanyayinti]

Thank you @ntakeda. That worked. Multi row formula... did the trick.