Counting cells in a table row that have data

[JimDandy]

I have a table with three columns of varying number of rows of data that I'd like to combine into one other row. I've seen some vba code that will do this quite well with regular rows and columns but I happen to be using an Excel table and I've been unable to find a workable solution. One trouble I've had is counting the rows of data. With regular Excel tabular data it's pretty straightforward but I could find nothing on counting active rows in an Excel table. I'm open to using VBA or formulas in the table.

It's simply 3 rows of random data of varying length that I'm combining into one...attached is an example worksheet with a table that shows the results I'm trying to achieve.

[YasserKhalil]

Hello
Try this code

Please Login or Register  to view this content.

[JimDandy]

Wow, that was great...thanks.

This worked great on my test tables which had the target columns contiguous. What would need to change if the columns were not in a row? I modified the attachment to be more like my source data.

[JimDandy]

...and could the code use named ranges?

[YasserKhalil]

Try this

Please Login or Register  to view this content.

[JimDandy]

Phenomenal...thank you very much!

[YasserKhalil]

You're welcome. Glad I can offer some help
Regards