New tables without blank rows.

**gringoto** · 02-09-2013, 10:53 AM

Hi, I'm trying to create some tables from another by criteria "TEAM".
I had little success but new tables were included blank rows and I made 4 tables with 15 rows.
I attached a picture what I want, but have no idea how to create.

Untitled.jpg

I hope someone to help.

**Palmetto** · 02-09-2013, 11:42 AM

Welcome to the forum.

Why not just sort the original table on the Team column?
You'll have them grouped in order. Isn't it redundent to repeat the header through the table?

**gringoto** · 02-09-2013, 01:13 PM

Thanks,
I neeed to create every new tables in diferent sheets.
Sheet1 - Original table.
Sheet2 - Team A
Sheet3 - Team B
Sheet4 - Team C
Sheet5 - Tean D

I've tried with VLOOKUP and INDEX, no result It made only one result(row)in every table, and many other things, bun I'm not so good in this.

I'd prefer to attach the file but I haven't got permition.